When I tried to make a copy of table I got this error “error 1060, duplicate column name “id” “. I am using sqlyog ver 3.5 and mysql 3.23.56. Thanks for the help!!!
This error should occur when you want to create/alter a table with two columns having the same name. Could you specify the the structure of the table to be copied?