Brian Dunning's Error Code Reference

MySQL Error 1110

SQLSTATE: 42000 (ER_FIELD_SPECIFIED_TWICE) Column '%s' specified twice

 

Comments

Themba Tjnas Ngobeni   Themba Tjnas Ngobeni, ExBSol Technologies
Aug 23, 2010
The error usually caused by a SQL statement/Dynamic Sql statement that specifies a column name twice and try to create a table or view and no unique alias is identified e.g create Table Themba.ThembaTemp as Select field1,field2,field3,field1 from Themba.temp;

correct:
create Table Themba.ThembaTemp as Select field1 as 'Themba',field2,field3,field1 as 'Themba2' from Themba.temp;