php - creating a table with a primary key that is auto increment with default values of 10000 -


"create table dummy ( tnum unsigned int not null auto_increment, primary key (tnum), )";  alter table dummy auto_increment = 10000; 

this not running. know causes error, , alternatives can create auto-incrementing primary key has default value of 10000.

unsigned great auto_increment columns! gives twice many possible values!

change query following:

create table dummy (     tnum int unsigned not null auto_increment primary key ) auto_increment=10000 

Comments

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -