Check if MySQL table exists without using “select from” syntax?

by

If you want to be correct, use INFORMATION_SCHEMA.

SELECT * 
FROM information_schema.tables
WHERE table_schema="yourdb" 
    AND table_name="testtable"
LIMIT 1;

Alternatively, you can use SHOW TABLES

SHOW TABLES LIKE 'yourtable';

If there is a row in the resultset, table exists.

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. Delete the entire content of all table in a Database [closed]
  3. MySQL pivot row into dynamic number of columns
  4. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  5. Calculate a running total in MySQL
  6. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  7. Difference between two dates in MySQL
  8. MySQL – Subtracting value from previous row, group by
  9. How do I restore a dump file from mysqldump?
  10. How do I create a sequence in MySQL?
  11. MySQL – Conditional Foreign Key Constraints
  12. MySQL search and replace some text in a field
  13. How to count items in comma separated list MySQL
  14. Groupwise maximum
  15. Group mysql query by 15 min intervals
  16. Error Code: 1406. Data too long for column – MySQL
  17. MySQL order by “best match”
  18. Using Count to find the number of occurrences
  19. Is there any reason to worry about the column order in a table?
  20. Checking a table for time overlap?
  21. Does mysql have the equivalent of Oracle’s “analytic functions”?
  22. MySQL INSERT INTO … VALUES and SELECT
  23. MYSQL select DISTINCT values in two columns
  24. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  25. Insert/ Update random date in MySQL
  26. Replace null with 0 in MySQL
  27. Get total hours worked in a day mysql
  28. How do you force mysql LIKE to be case sensitive? [duplicate]
  29. In what order are MySQL JOINs evaluated?
  30. ORDER BY alphabet first then follow by number

Leave a Comment