how to set the initial value of a column to 1

sandeepmoodle1 · September 29, 2011, 1:09am

hi,
i need to know how to set the initial value of a column to 1.
it is taking 0 and increasing.I want it to start at 1. i have tried default 1 but it is not working …help!

gmouse · September 29, 2011, 3:55am

The default value should work. What is your insert query?

Topic		Replies	Views
Altering default column value SLOW! Other MySQL® Questions	2	631	January 17, 2010
Auto Increment error Other MySQL® Questions	1	506	September 26, 2008
increase int column via UPDATE, without SELECT Other MySQL® Questions	1	345	September 7, 2007
Duplicate entry '1' for key 1 Other MySQL® Questions	1	393	April 6, 2008
resetting auto_increment_increment and auto_increment_offset back to defaults Other MySQL® Questions	0	889	September 11, 2018

how to set the initial value of a column to 1

Related topics