fyi I'm using mysql 3.22.32
I've either got the field setup incorrectly or just cannot figure out how to get an insert to work when add an auto_increment field.
I've tried many but i'll use the following for an example
insert into universe (cluster,galaxy,planet,planet_name,ruler,size,score,coords,rank) values (12,6,5,"\"House Of God\"","\"Hoppermania\"",1618,12488948,"12:6:5",856)
there is a 10th field called id which is auto_increment. Without that field the insert works fine. When I add that field to the table i get the following error.
Column count doesn't match value count at row 1
I know this is really simple, I am just missing something obvious.
I've either got the field setup incorrectly or just cannot figure out how to get an insert to work when add an auto_increment field.
I've tried many but i'll use the following for an example
insert into universe (cluster,galaxy,planet,planet_name,ruler,size,score,coords,rank) values (12,6,5,"\"House Of God\"","\"Hoppermania\"",1618,12488948,"12:6:5",856)
there is a 10th field called id which is auto_increment. Without that field the insert works fine. When I add that field to the table i get the following error.
Column count doesn't match value count at row 1
I know this is really simple, I am just missing something obvious.