Reference: MySQL Error 1110

SURVEY: Which web technology do you prefer?

View the results

ChartMaker Pro 7

Charts and graphs in your FileMaker 5/6/7/8 solution without a plug-in. Click here.

2010-08-23 07:15:20
Themba Tjnas Ngobeni Themba.Ngobeni@gmail.com
ExBSol Technologies

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;

This is my note and I want to edit it | Report an inappropriate comment