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

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

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 T

Re: List of Tables

2003-02-20 Thread Kamara Eric R-M
Hi, Have u thought of sending an sql query like "show tables" and then looking at what it returns? Eric On Thu, 20 Feb 2003, 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 > th

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

RE: List of Tables

2003-02-20 Thread Jennifer Goodie
SHOW TABLES; Then treat the output as a normal result set. see the manual for more about SHOW syntax http://www.mysql.com/doc/en/SHOW.html -Original Message- From: Jeff Pearson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 2:31 PM To: [EMAIL PROTECTED] Subject: List of

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 be G

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 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

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 ' 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 >

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 - Befor