Mysql duplicate rows (ignore id + timestamp) without naming all other columns in the query?
duplicates, mysql
Solution
Note: Being that this is the top google result for 'workbench how to duplicate a row' I feel inclined to provide an answer for that question. If a moderator feels this is inappropriate; feel free to help resolve the inappropriation.
Select all columns (or your target columns) from a single table, without joins or anything else that restricts in-editor inserts.
Eg: `SELECT * FROM mytable ORDER BY id DESC`
right-click on the row you want to copy, Copy Row
Go to the bottom of the select results, end, there should be a line with all `null`'s
right-click on the null'ed row, Paste Row
Don't forget to nullify, or set to be the default, any columns you want to keep; like the primary index/id, or any unique constrained columns!
To insert your duplicated row use the Apply button on the lower right.
Workbench will open a dialog and show your the generated insert statements and offer to execute them for you. Permitting there are no errors you have just duplicated a row!
Run your select statement again to see your results.
Problem
I have tried to make this question concise in the title. There are many answers to similar questions, but all involve naming every column in the table in the query. What I want is a query to show me duplicate rows, but to ignore one or two columns, and I would like to be able to do it like shown in this post Return duplicate records, but without having to explicitly name every column in the table. Is it possible?