I have 2 tables with identical structures. The following sql statement works
fine:
insert into table_2 select * from table_1
but if I attempt to say
insert into table_2 select fieldname_1 from table_1
or any combination of selecting specific fields to be put into the other
table, I get an error which is "column count doesn't match value count at
row 1"
I suspect this has something to do with an auto-increment ID field and/or a
primary key on ID.
Does anyone know how I can overcome this?
I have also used replace into table_2 select * from table_1 with the same
problems. what I am ultimately trying to do is to have one table go and get
certain information from the other table to update itself from the other
table. I don't really want to dump all fields from one into the other.
Thanks for your help
