How to create sequence in MySQL

byTechdoc •
0

 how to Manage sequences in MySQL

use <db>;

CREATE TABLE sequence (id INT NOT NULL);

INSERT INTO sequence VALUES (0);

select * from sequence;

set sql_safe_updates=0;

UPDATE sequence SET id=LAST_INSERT_ID(id+1);

SELECT LAST_INSERT_ID();




Tags:

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post