Sql error 1109 - Mysql error 1109 - Error: 1109 sqlstate: 42s02 (er_unknown_table) - Error: 1109 – SQLSTATE: 42S02 ER_UNKNOWN_TABLE | idError.com-The largest database with errors and solutions!

Home > MySql-Server

Error: 1109 - SQLSTATE: 42S02 ER_UNKNOWN_TABLE

March 11th, 2009

Goto solutions Leave a solution

Description:
Message: Unknown table ‘%s’ in %s

MySql-Server #1109 sql, 42s02 sql error, error 1109 42s02, error 1109:42s02, error 1109mysql, error: 1109 sqlstate: 42s02 (er_unknown_table), google sql error 1109, java sql 42s02, lrm-00118: syntax error at '=' at the end of input, mysql error 1109, mysql error 1109 42s02, oracle　sqlstate[42s02], sql 42s02 error, sql errior 1109, sql error 1109, sql error: 1109, sqlstate: 42s02, sql error: 1109, sqlstate: 42s02 hibernate oracle mysql, sql server 42s02, sql server error 1109, sql state 42s02 oracle, sql-42s02

Solutions (1) Trackbacks (0) Leave a solution Trackback

admin
April 8th, 2009 at 15:18 | #1
Reply | Quote
This error occurs when table is being referenced in a query, usually in WHERE clause, without declaring it in the table. Declare first the table in the FROM clause or use JOIN clause.

No trackbacks yet.

Permission denied Error: 1103 – SQLSTATE: 42000 ER_WRONG_TABLE_NAME