12-14-2010 05:08 PM
I have mi table in MySQL, mi conection is ok, I can see the data in every table, but, when I want insert value in database in array form, I can't...
How I need insert this values in every columns except in the first one, this is the ID and is Autoincrement, i dont want put anything there...
12-14-2010 09:32 PM
This error is correct you are passing 3 columns and specifying that 4 columns are expected in the insert.
you need a different insert.
INSERT INTO preuba (column2, column3, column4) VALUES (val2, val3, val4)
12-15-2010 05:09 PM
You rigth! My error was not puting in "0" the first value for the autoincrement. I use the query INSERT INTO blabla VALUE (0,"VAL1","VAL2",..."VALN"), thanks for the help...
12-16-2010 07:57 AM
Glad it worked. Actually the error messages from the DB toolkit are very good, much better than most code I see. I was able to learn most of my database from the error messaged on the toolkit.