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

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.

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. Unknown column in ‘field list’ error on MySQL Update query
  3. Unknown column in ‘field list’ error on MySQL Update query
  4. MySQL – Operand should contain 1 column(s)
  5. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. MySQL create table if not exists and insert record only if table was created
  8. How do I use properly CASE..WHEN in MySQL
  9. How can I do a FULL OUTER JOIN in MySQL?
  10. MySQL query String contains
  11. What’s the difference between VARCHAR and CHAR?
  12. Case statement in MySQL
  13. How to declare a variable in MySQL?
  14. MySQL Cannot Add Foreign Key Constraint
  15. How to split the name string in mysql?
  16. How do I import an SQL file using the command line in MySQL?
  17. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  18. mysql Foreign key constraint is incorrectly formed error
  19. MySQL: Invalid use of group function
  20. How can I return pivot table output in MySQL?
  21. Compare dates in MySQL
  22. MySQL “WITH” clause
  23. MySQL Multiple Joins in one query?
  24. Error Code: 2013. Lost connection to MySQL server during query
  25. MySQL syntax for Join Update
  26. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  27. how to drop partition without dropping data in MySQL?
  28. MySQL combine two columns into one column
  29. Simple way to calculate median with MySQL
  30. Error 1046 No database Selected, how to resolve?
  31. MySQL Error 1264: out of range value for column
  32. Remove duplicate rows in MySQL
  33. How to SUM and SUBTRACT using SQL?
  34. Cast from VARCHAR to INT – MySQL
  35. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  36. How do you force mysql LIKE to be case sensitive?
  37. MySQL – UPDATE multiple rows with different values in one query
  38. How to create a MySQL hierarchical recursive query?
  39. ERROR 1148: The used command is not allowed with this MySQL version
  40. Insert into a MySQL table or update if exists
  41. How to round down to nearest integer in MySQL?
  42. MySQL starts with searching issue
  43. Query to convert from datetime to date mysql
  44. Is it possible to GROUP BY multiple columns using MySQL?
  45. MySQL error: key specification without a key length
  46. Best way to test if a row exists in a MySQL table
  47. MySQL equivalent of DECODE function in Oracle
  48. mysql update column with value from another table
  49. The used SELECT statements have a different number of columns
  50. How to delete from multiple tables in MySQL?
  51. MySQL: Can’t create table (errno: 150)
  52. How to copy a row and insert in same table with a autoincrement field in MySQL?
  53. Join vs. sub-query
  54. Alternative to except in MySQL
  55. Equivalent of explode() to work with strings in MySQL
  56. ROW_NUMBER() in MySQ
  57. MySQL OPTIMIZE all tables?
  58. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  59. MySQL – Get row number on select
  60. MySQL error: Unknown column in ‘where clause’
  61. How to truncate the text returned for a column in a MySQL query
  62. Using union and order by clause in mysql
  63. MySQL LIKE IN()?
  64. Conversion failed when converting date and/or time from character string while inserting datetime
  65. error, string or binary data would be truncated when trying to insert
  66. Using group by on multiple columns
  67. ORA-01843 not a valid month- Comparing Dates
  68. How do I escape a single quote in SQL Server?
  69. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  70. How to join two tables by multiple columns in SQL?
  71. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  72. Insert text with single quotes in PostgreSQL
  73. SQL Server IF NOT EXISTS Usage?
  74. How to insert date values into table
  75. How to join two tables by multiple columns in SQL?
  76. Arithmetic overflow error converting numeric to data type numeric
  77. I want to use CASE statement to update some records in sql server 2005
  78. how to remove time from datetime
  79. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  80. Subtract one day from datetime
  81. Backup a single table with its data from a database in sql server 2008
  82. updating table rows in postgres using subquery
  83. Is there a coalesce-like function in Excel?
  84. PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/website/public_html/facebook/fbclogin.php on line 57 [duplicate]
  85. Is merge statement available in MySQL
  86. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  87. How to retrieve sticky post in raw sql?
  88. Backticks (`) Instead of Single Quotes (‘) in an SQL Statement?
  89. SQL User Query by Multiple Roles using PHP
  90. $wpdb get_var issue
  91. Inserting rows into a custom table, when plugin is activated
  92. Posts modified in the last 48 hours
  93. Why this query is not showing any result on wordpresss home page?
  94. making php value numeric
  95. post id not displaying
  96. How to run complex query using PHP
  97. Bulk find & replace on WordPress posts/pages (minus image paths)
  98. Improving performance of SQL sub-queries in WordPress
  99. Insert multiple checkbox values
  100. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta

Leave a Comment

tech