List of tables.

2005-02-18 Thread Mohsen Pahlevanzadeh
Dears,Problem of my Makefile is solved. But i have a new problem: I need to create an array of my DB's tables. I have saw mysql_list_tables() function,But it returns a result of sql. Please help me... Yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: List of tables.

2005-02-18 Thread Peter Brawley
Mohsen, not sure what you mean here, to get a list of tables in a db you have to issue an sql request, which is all mysql_list_tables() does (http://dev.mysql.com/doc/mysql/en/mysql-list-tables.html). PB Mohsen Pahlevanzadeh wrote: Dears,Problem of my Makefile is solved. But i have a new

Re: List of tables.

2005-02-18 Thread Mohsen Pahlevanzadeh
Dear Peter, I need to name of each table,But mysql_list_tanles() creates a sql result. Can i make an array from those names?Each element of that is a name of table. Please guide me. regards Mohsen, not sure what you mean here, to get a list of tables in a db you have to issue an sql

List of Tables

2003-02-20 Thread Jeff Pearson
I am writing a vb.net application to do some db management on MySQL. Ive got it pretty far but am at a point where I am stuck. I know with php there is a list tables function. Does anyone know of a way to list the tables of a given database outside of php? Any help would be GREATLY appreciated

Re: List of Tables

2003-02-20 Thread Daniel Kasak
Jeff Pearson wrote: I am writing a vb.net application to do some db management on MySQL. Ive got it pretty far but am at a point where I am stuck. I know with php there is a list tables function. Does anyone know of a way to list the tables of a given database outside of php? Any help would

RE: List of Tables

2003-02-20 Thread Jennifer Goodie
of Tables I am writing a vb.net application to do some db management on MySQL. Ive got it pretty far but am at a point where I am stuck. I know with php there is a list tables function. Does anyone know of a way to list the tables of a given database outside of php? Any help would be GREATLY

Re: List of Tables

2003-02-20 Thread Jerry
show tables; ? or do you mean specific to vb ? Jerry - Original Message - From: Jeff Pearson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 20, 2003 10:31 PM Subject: List of Tables I am writing a vb.net application to do some db management on MySQL. Ive got

Re: List of Tables

2003-02-20 Thread Kamara Eric R-M
there is a list tables function. Does anyone know of a way to list the tables of a given database outside of php? Any help would be GREATLY appreciated. Jeff Pearson - Before posting, please check: http://www.mysql.com

list of tables in a database

2002-01-16 Thread Bret Ewin
I need to know how to get a list of all the tables in a database. In Oracle you could select OWNER, TABLE_NAME from ALL_TABLES to get a list of all tables and their schemas. How does one do this in MySQL? Thanks, Bret - Before

Re: list of tables in a database

2002-01-16 Thread John Kemp
show tables will get you a list of tables. To get the schema of tables type 'describe tablename' J Bret Ewin wrote: I need to know how to get a list of all the tables in a database. In Oracle you could select OWNER, TABLE_NAME from ALL_TABLES to get a list of all tables and their schemas

Re: list of tables in a database

2002-01-16 Thread jr
Show Tables; - VirtualChicagoLand.com Is Your Chicagoland Resource! Visit: http://VirtualChicagoLand.com On Wed, 16 Jan 2002, Bret Ewin wrote: I need to know how to get a list of all the tables in a database. In Oracle you could select OWNER, TABLE_NAME from ALL_TABLES to get a list