Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages

Shopping Cart
Shopping Cart


Free Newsletter


Privacy Policy

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.


 Reference: MySQL Error 1110

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

FileMaker Error Codes

Lasso Error Codes

MySQL Error Codes

Windows System Errors

About this database
This is a free public resource. It is unmoderated and operates on the "public virtue" system. I hope you find it useful!

User Contributed Notes

2010-08-23 07:15:20
Themba Tjnas Ngobeni
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;

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

+ Add your own note