Insert into .. Select

[fesan]

Hello....

I want to copy a whole row from one table to another.

I found the INSERT INTO .. SELECT function, but i want to "simplify" it if possible.

 

as i understood i have to write out every field that i want to insert to, but i want to insert in to every field. it there a way to use * in this function?

 

I want to do this because the table I'm inserting to is a history table... so when ever a field in the mail table is updated a copy of the old one is inserted in to the history table....

[Mchl]

http://dev.mysql.com/doc/refman/5.1/en/insert-select.html

 

The (col_name,...) is in [], which means it is optional. I never tried it, but I think it should work as long as both tables have exactly same columns in exactly same order.

[fesan]

ok....

 

well, i have added one field to the history table.

this is because i want to keep the id from the old table and make a new id in the history table....

 

I'll try it out and see how it goes!

 

thanks!

[fesan]

Now I've solved out some issues but i still get a error:

 

Column count doesn't match value count at row 1

 

I've deleted the extra id field, and made the two tables exactly the same....

Could this be the Auto increment i have on my main table that is failing?

 

Because the ID field in my history table is not an auto increment field.

[fenway]

We can't guess your statement or your table structures.