There's a trick for using LAST_INSERT_ID() to generate sequences in MySQL. Quoting from the Manual: Create a table to hold the sequence counter and initialize it: mysql> CREATE TABLE sequence (id INT NOT NULL); mysql> INSERT INTO sequence VALUES (0); Use the table to generate sequence numbers like this: mysql> UPDATE sequence SET id=LAST_INSERT_ID(id+1); mysql> [...]
Apparently the message from the comic below was not well conceived. Following the strip I've added some spoiler notes. This is not about bashing NoSQL. Apparently some people feel this way. This is about: Trying to judge/analyze NoSQL as if it were a single entity, thereby asking "should I use MySQL or NoSQL"? The fact [...]