• Register
0 votes

Problem :

I am trying to import mySql database which was originally an access database into phpmyadmin and its giving me following error:
incorrect table definition; there can be only one auto column and it must be defined as a key
6 5 3
6,930 points

1 Answer

0 votes

Solution :

For those of you that got here in search of the #1075 error  then you should know that this happens if you set your index /autoincrement column in the form at first after that added some new columns and then at last wanted to submit the form. I guess when you add more columns the phpMyAdmin does some kind of background refresh and loses the "primary" information. So you still see it in your form but in the background in the SQL query it does not have this information any more.

So the solution is to deselect your primary column and set it again. It solves my issue.

9 7 4
38,600 points

Related questions

0 votes
1 answer 6 views
I want to know how to store multiple values in single column in MysQl.
asked Sep 29 Daniel Anderson 4k points
0 votes
1 answer 5 views