MySQL Forums
Forum List  »  Newbie

Re: AUTO_INCREMENT Problem.
Posted by: Priscila Galvao
Date: April 27, 2015 04:04PM

Steve,
This error happens when the number of values you are trying to insert is bigger than the number of columns on the table.
Try to do one insert with each name you want to add to the table. For example: insert into my_table(My_NAMES) values ('Barry');
or
insert into my_table(id, My_NAMES) values ('','Barry');
I hope that works.
Regards,
Priscila

---------------------------------------
Priscila Galvao
MySQL Sales Consultant

Options: ReplyQuote


Subject
Written By
Posted
April 27, 2015 03:26PM
Re: AUTO_INCREMENT Problem.
April 27, 2015 04:04PM
April 27, 2015 04:39PM
April 28, 2015 05:37AM
April 28, 2015 09:07AM
April 28, 2015 04:14PM
April 28, 2015 05:05PM
April 29, 2015 05:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.