MySQL Forums
Forum List  »  InnoDB

InnoDb & select problem...
Posted by: Arturo Salvamante
Date: January 03, 2005 06:56PM

how will i know if my engine is InnoDB or MYISAM? and i have this another problem...

mysql> select username.user,thread_id.msg from users,message;
ERROR 1109: Unknown table 'username' in field list

why is that I always got that error msg. where in fact i have field 'username' in my table 'users'...

Options: ReplyQuote

Written By
InnoDb & select problem...
January 03, 2005 06:56PM
January 03, 2005 07:10PM
April 21, 2005 01:00AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.