* marc malacarme > I canıt seem to make any of the describe or show queries work > when I apply a search statement: > Query=show table status from demo; > Works fine. Now Iım trying to get info from only one table: > Query=show table status from demo where name like "user_access"; > Does no work.
The manual is your friend: <URL: http://www.mysql.com/doc/S/H/SHOW_TABLE_STATUS.html > Syntax: SHOW TABLE STATUS [FROM db_name] [LIKE wild] In other words: remove "where name" from your query. -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
