how can you add value 0 into mysql?

hydro · 09-20-2003, 01:45 PM

developers_id int(5) NOT NULL auto_increment,

Adding (0) will not work, it gets the next number in the auto_increment, but I need to add the row where developers_id = 0, how can I do this

Saraev · 09-20-2003, 03:30 PM

kinda crude, and this won't work easily if there's already data in it, but create the table as "developers_id int(5) NOT NULL"
then add your developers_id == 0 with an insert, then run
"alter table deve MODIFY developers_id int(5) primary key auto_increment;"

It worked on my test machine, but again, if there's data there already it might not be the cleanest solution.

hydro · 09-21-2003, 12:14 PM

What I did was add it, then just set it to 0 :/