Re[2]: [PHP] Checking whether a MySQL table exists
| From: | David Tod Sigafoos | Date: | Tue, 09 Jan 2001 22:16:33 +0000 |
| Subject: | Re[2]: [PHP] Checking whether a MySQL table exists | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-33565@lists.php.net to get a copy of this message | ||
True .. but here you will have to parse the info .. 'select * from
table limit 1' will bring back and error pretty quickly with only a
check for DIE
PO> http://www.php.net/manual/function.mysql-list-tables.php
>> BW> Is there a command to check for the existence of a MySQL table?
>>
>> I believe you must 'select' the table and check the error
>>
>> On creation you can create table xzy IF NOT EXISTS
--
DSig
David Tod Sigafoos
mailto:dsig@teleport.com
Using 'The Bat' 1.48f
`````
( O O )
_______oOOo__( )__oOOo_______