Alex Rivera | Logout

Copying rows in MySQL

Asked 2008-10-23T14:38:58.093
14

I want to copy all of the columns of a row, but not have to specify every column. I am aware of the syntax at http://dev.mysql.com/doc/refman/5.1/en/insert-select.html but I see no way to ignore a column.

For my example, I am trying to copy all the columns of a row to a new row, except for the primary key.

Is there a way to do that without having to write the query with every field in it?

Edit
Report

1 Answer

1

No, this isn't possible.

But it's easy to get the column list and just delete which one you don't want copied this process can also be done through code etc.

answered 2008-10-23T14:57:17.510

Your Answer