Skip to content

Instantly share code, notes, and snippets.

@jcisio

jcisio/update.sql

Created November 23, 2017 11:26
Show Gist options
  • Save jcisio/06aa0c02e61d6a693dcaee71ad2fb068 to your computer and use it in GitHub Desktop.
Save jcisio/06aa0c02e61d6a693dcaee71ad2fb068 to your computer and use it in GitHub Desktop.
Download ZIP
Update nodes to the last revisions
Raw
update.sql
UPDATE node
JOIN (SELECT nid, max(vid) as vid FROM node_revision GROUP BY nid) as tv USING(nid)
SET node.vid = tv.vid
WHERE node.type = 'cours'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment