Is there a way to find out if a table exists?

[Dan Anderson]

I am trying to make my PHP script autodetect when a table in a mySQL
database exists, and when it doesn't, create it.  

Is there some way to do something like:

SELECT * FROM tables WHERE name = table_name;

And get a result I could test for truth, and thus run my script?

Thanks in advance,

Dan


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Is there a way to find out if a table exists?

[Roger Baklund]

* Dan Anderson
 I am trying to make my PHP script autodetect when a table in a mySQL
 database exists, and when it doesn't, create it.

 Is there some way to do something like:

 SELECT * FROM tables WHERE name = table_name;

 And get a result I could test for truth, and thus run my script?

SHOW TABLES LIKE table\_name;

Note that the underscore must be escaped with a backslash, because the LIKE
operator use underscore as a wildcard for a single character. In other
words, this statement:

SHOW TABLES LIKE table_name;

... would match table_name, but also tableAname and tableBname.

--
Roger


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Is there a way to find out if a table exists?

[Jennifer Goodie]

 Is there some way to do something like:
 
 SELECT * FROM tables WHERE name = table_name;
 
 And get a result I could test for truth, and thus run my script?

Show tables like 'table_name';

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Is there a way to find out if a table exists?

[Don Read]

On 19-Sep-2003 Dan Anderson wrote:
 I am trying to make my PHP script autodetect when a table in a mySQL
 database exists, and when it doesn't, create it.  
 
snip

function tableexists($tbl) {
$res = @mysql_query(SELECT 1 FROM $tbl);
return ($res ? true : false);
}


Regards,
-- 
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Is there a way to find out if a table exists?

[Don Read]

On 19-Sep-2003 Don Read wrote:
 
 On 19-Sep-2003 Dan Anderson wrote:
 I am trying to make my PHP script autodetect when a table in a mySQL
 database exists, and when it doesn't, create it.  
 
 snip
 
 function tableexists($tbl) {
 $res = @mysql_query(SELECT 1 FROM $tbl);
 return ($res ? true : false);
 }
 

Err ... make that 

 $res = @mysql_query(SELECT 1 FROM $tbl LIMIT 1);


-- 
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Is there a way to find out if a table exists?

[Paul DuBois]

At 3:37 PM -0500 9/19/03, Don Read wrote:
On 19-Sep-2003 Don Read wrote:
 On 19-Sep-2003 Dan Anderson wrote:
 I am trying to make my PHP script autodetect when a table in a mySQL
 database exists, and when it doesn't, create it. 

 snip

 function tableexists($tbl) {
 $res = @mysql_query(SELECT 1 FROM $tbl);
 return ($res ? true : false);
 }
Err ... make that

 $res = @mysql_query(SELECT 1 FROM $tbl LIMIT 1);
Better yet, SELECT 1 FROM $tbl WHERE 1 = 0, which returns even
fewer rows. :-)
Or use SHOW TABLES LIKE 'name of table here' or
SHOW TABLE STATUS LIKE 'name of table here' and see if you
get any row back.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]