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` […]