I have a table with column titles as: (id, price,quality,deadline,UtilityValue,sellerNumber) which Id is an AUTO_INCREMENT!
now I want to copey this table to another table with the exact same column titles. till here every thing is ok! but I DONT want to copy the id field. what I want is that I copy the data of each row except id which should be filled AUTO_INCREMENTAly.
so I write below code:
and I get this error:
I guess it error is related to the id column which I didn't mentioned in insert into query. Am I right? If yes Do you know how can I correct it?
Thank you sooo much!