Equivalent SELECT for SHOW command
Hello all, Are there any system_table which I can to do a pure SELECT command to get the same results that MySql SHOW command, in the same way that Oracle DB ? Thanks.. - 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
INNODB / Foreign Keys / mysqldump
Hello all, I am testing MySql Max 4.0.1 alpha. I have configured innodb tablespace and created the two manual tables example. But when I try to do a mysqldump to re-create the tables on another DB or 'SHOW CREATE TABLE child', NO-FOREIGN key information is gathered on results. However 'SHOW TABLE STATUS FROM yourdatabasename LIKE 'T'' command is showing me right information and the foreign-key behavior is running fine. Thanks and best regards.. - 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