What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this possible
with MySQL or do I need to create a condition within PHP?
Thanks,
Ed
mysql
-
show tables from databasename;
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 17 February 2003 16:11
To: [EMAIL PROTECTED]
Subject: Checking existence of a table.
What query would I use to check for an existence of a table within a
database? I'm
At 11:10 -0500 2/17/03, [EMAIL PROTECTED] wrote:
What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this possible
with MySQL or do I need to create a condition within PHP?
You can check the output of SHOW TABLES or
Thanks for all the replies. I've got a hnadle on it now.
Ed
On Mon, 17 Feb 2003, Paul DuBois wrote:
At 11:10 -0500 2/17/03, [EMAIL PROTECTED] wrote:
What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this
On 17-Feb-2003 [EMAIL PROTECTED] wrote:
What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this possible
with MySQL or do I need to create a condition within PHP?
Thanks,
function tableexists($tbl) {
Ed,
What query would I use to check for an existence of a table within a
database? I'm currently writting a set of scripts in php. Is this possible
with MySQL or do I need to create a condition within PHP?
In MySQL, you can issue:
SHOW TABLES [FROM your_database] LIKE 'your_pattern'
Where
Hi Ed,
What query would I use to check for an existence of a table within a
database?
SHOW TABLES LIKE 'table_name';
might help.
prosit
Klaus
-
Before posting, please check:
http://www.mysql.com/manual.php (the