Changing the serial id of a field
Submitted by system on Mon, 01/06/2014 - 14:15There are times when the serial field needs to start from a number other than 1. To do so the following sql query will do the task. It sets the start number to be 100404.
alter table serial_table_field_name auto_increment = 100404;