KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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?
Tags (comma-separated)
Save Edits
Cancel