mysql
Creating sequences in MySQL an alternative to AUTO_INCREMENT
MySQL doesn’t doesn’t have sequences and Auto_Increment does not suffice the need for a text based sequence generator. Or say you want to reset AUTO_INCREMENT’s value? So here’s a workaround for a generating a sequence in MySQL which can be reset later. Step 1: Create a Table CREATE TABLE IF NOT EXISTS `seqgen` ( `seqno` … Continue reading
Categories: mysql, php
Leave a comment