PHP: Check if MySQL TABLE already exists as an error condition?

Question

How in PHP would I check for a condition if a MySQL TABLE already exists and it shouldn't and need to abort but with a message that's meaningful? Thanks!

Answer 1

Try creating the table. You should get an error: 1050 "table already exists".

Or you can try this: https://stackoverflow.com/a/1525801/2427840

Answer 2

mysql_ - functions are deprecated as of PHP 5.5.0. You should use MySQLi or PDO.

To check if a table exists you can use this query:

SELECT COUNT(*)
FROM information_schema.tables 
WHERE table_schema = '[database-name]' 
AND table_name = '[table-name]';

Answer 3

Simple use:-

$result = mysql_query("SHOW TABLES LIKE 'table_name'");
$tableExist = mysql_num_rows($result) > 0;
if($tableExist)
echo "Table Exist";