• 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

Please log in or register to answer this question.

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 11 views
I want to know how to store multiple values in single column in MysQl.
asked Sep 29, 2020 Daniel Anderson 4k points
0 votes
1 answer 43 views
Problem: When i try to setup my databse using xampp phpmyadmin i am getting an 1932 error table 'phpmyadmin.pma__tracking' doesn't exist in engine. I need assistance how can we overcome this error.
asked Nov 13, 2020 prog_learner 2.5k points
0 votes
1 answer 7 views
0 votes
1 answer 17 views
1 vote
2 answers 66 views
Problem : I am very new to XAMPP. I have recently installed the XAMPP on the Windows machine. But suddenly I have started getting below error: Connection for controluser as defined in your configuration failed. I had my MySQL database installed on my Windows machine and ... access my index.php I guess something is wrong with my XAMPP installation. Can I have expert help on above issue to fix it?
asked Apr 13, 2020 morrisBson 3.2k points
0 votes
1 answer 18 views
0 votes
1 answer 18 views
I need to copy a table information from one database to another table of another database. Is it possible for me to do it? if it is, can someone help me? Thank you!
asked Oct 12, 2020 robin_gallo 420 points
0 votes
1 answer 12 views
0 votes
1 answer 114 views
Problem: Can anyone give the right solution by filling in the blanks? A _____ key is defined as a key that is used strictly for data retrieval purposes? a. lookup b. foreign c. candidate d. secondary
asked Feb 23, 2020 maddi86 5.4k points