Can you change the auto_increment default value after data has been entered? When I created the table I did not specify a default value.
I have since removed all data from the table,
Deleted the field and re-created,
but if set the default to say 10000, it goes thru with no errors, but when I go back to check there is nothing in the default column and new records start back at 0.
[SOLVED] auto_increment
Moderator: General Moderators
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
the next auto_increment value is stored outside the table's normal structure, in it's properties.
viewtopic.php?t=26552
viewtopic.php?t=26552
Doesn't seem to do it...
I tried setting it at the MySQL command line using the command you refered me to. I've also tried using phpmyadmin... no luck It goes thru like its supposed to but the value is not there when you go back and look at the table config.
This table is a InnoDB and the field is a PK and also a FK in another table, but there is no data in the other table.
I tried setting it at the MySQL command line using the command you refered me to. I've also tried using phpmyadmin... no luck It goes thru like its supposed to but the value is not there when you go back and look at the table config.
This table is a InnoDB and the field is a PK and also a FK in another table, but there is no data in the other table.