Hi r937 and Thank you for your reply. I see what you mean about the primary key. Ok, then if you wanted to duplicate all the information in a row, and make a new row except with an incremented value for the primary key, how would you do that?
George: I guess I am missing something based on your response, "But why?" My frequent scenario is that I have a table with about 30 columns, and each cell has a significant amount of data. But sometimes, I need to add a row with very similar data as an existing row. So the quickest way to add a row with mostly the same data is to
1. duplicate it with an incremental primary key, then
2. make the minor change(s) in the new row's cells as I wish.
This is much quicker than adding a new, empty row and then re-typing or copying and pasting into each of the 30 cells. Geddit? What would you do in this scenario?
Hello again. Well I finally used this. Here's what I ran in the SQL editor of the MySQL-Front app:
WHERE id = 23748
And here's the error message I got:
SQL execution error # 1064. Response from the database:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ad_off_name','active_a','ad_ofr_nae' at line 3
23748 is the value of the auto_increment and primary key column for the row to be duplicated. There are no typos in the column labels, since didn't re-type anything. I exported, coverted tabs to ',' and pasted into the query.