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


Subject
Views
Written By
Posted
InnoDb & select problem...
2959
January 03, 2005 06:56PM
2094
January 03, 2005 07:10PM
2154
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.