Settings and activity
2 results found
-
16 votes
An error occurred while saving the comment Anonymous supported this idea · -
74 votes
An error occurred while saving the comment Anonymous commentedToad for MySQL does this automatically (in case that provides any extra motivation to get it done!)
Anonymous supported this idea ·
I'd add another one that is very useful, in your example, if you select the three ID values then it should copy
(1, 2, 3)
and possibly
id IN (1, 2, 3)
or if you copy the first and second role then it should copy
('ADMIN', 'CLERK')
or even
role IN ('ADMIN', 'CLERK')
Toad for MySQL has this feature