Skip to content

Instantly share code, notes, and snippets.

@bcmiller
Created February 28, 2012 20:04
Show Gist options
  • Save bcmiller/1934771 to your computer and use it in GitHub Desktop.
Save bcmiller/1934771 to your computer and use it in GitHub Desktop.
node-rev
mysql> select * from uuid_node where nid=2457738;
Empty set (0.00 sec)
mysql> select * from uuid_node_revisions where nid=2457738;
Empty set (0.05 sec)
mysql> select nid,from_unixtime(changed) from node where nid=2457738;+---------+------------------------+
| nid | from_unixtime(changed) |
+---------+------------------------+
| 2457738 | 2012-02-27 16:14:42 |
+---------+------------------------+
1 row in set (0.00 sec)
mysql> select nid,title,from_unixtime(changed) from node where nid=2457738;
+---------+----------------------+------------------------+
| nid | title | from_unixtime(changed) |
+---------+----------------------+------------------------+
| 2457738 | Discover for Coaches | 2012-02-27 16:14:42 |
+---------+----------------------+------------------------+
1 row in set (0.00 sec)
mysql>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment