How to read table names within database?
Hi, I notice that lots of mysql gui's all can find out the contents (tables) of any given database, how do they do this? Is it an sql command? I hope so, I need to know what the SQL command is so I can pass it to perl DBI. M. -- Mark Worsdall https://www.paypal.com/refer/pal=LS79YHQ9VUGLJ - 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
Re: How to read table names within database?
show tables from database; - Original Message - From: Mark Worsdall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 2:42 PM Subject: How to read table names within database? Hi, I notice that lots of mysql gui's all can find out the contents (tables) of any given database, how do they do this? Is it an sql command? I hope so, I need to know what the SQL command is so I can pass it to perl DBI. M. -- Mark Worsdall https://www.paypal.com/refer/pal=LS79YHQ9VUGLJ - 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 - 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
Re: How to read table names within database?
The command show tables; will give you what you want. See: http://www.mysql.com/doc/en/SHOW.html Gurhan On Fri, 2002-09-06 at 02:42, Mark Worsdall wrote: Hi, I notice that lots of mysql gui's all can find out the contents (tables) of any given database, how do they do this? Is it an sql command? I hope so, I need to know what the SQL command is so I can pass it to perl DBI. M. -- Mark Worsdall https://www.paypal.com/refer/pal=LS79YHQ9VUGLJ - 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 - 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
Re: How to read table names within database?
On Fri, 6 Sep 2002, Mark Worsdall wrote: Hi, I notice that lots of mysql gui's all can find out the contents (tables) of any given database, how do they do this? Is it an sql command? I hope so, I need to know what the SQL command is so I can pass it to perl DBI. M. Try show tables; -@- -- 1031295017 - 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
Re: How to read table names within database?
Mark, I notice that lots of mysql gui's all can find out the contents (tables) of any given database, how do they do this? Is it an sql command? Parse the contents of SHOW DATABASES and then use the ouput of that to SHOW TABLES... mysql, query. DSL - 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
