Mysql: data insertion and autoincrement
I am switching from accessing mysql
I have a table in access where one of the columns is autonumber
when i transfer data to mysql database (where i also have a column that is auto_increment) should i pass auto_increment data to auto_increment column or will it auto-specify itself?
How can I ensure that if I do not pass the auto-enter data from access, that it will automatically start?
+2
a source to share
1 answer
If you don't want to store the auto-incrementing number, just don't put it in this field. He will enlarge himself.
But in all likelihood, you would like to keep it (if not used, why is it there?) And with MySQL (unlike some other systems like SQL Server), you can insert values into auto-increment columns without setting any parameters to do this.
+3
a source to share