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 re

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 problem

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 management on MySQL. Ive > got

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 Tabl

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

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 > tables and their schemas. How d