Check MySQL Table Existence: Quick Guide

1 year ago
Olivia Parker
1 minute

In MySQL, there are two methods that can be used to check if a table exists:

  1. “Using the SHOW TABLES statement:”
SHOW TABLES LIKE '表名';

This statement will return a result set that includes the table name if the table exists, but will not return any results if the table does not exist.

  1. Utilize the INFORMATION_SCHEMA database:
SELECT table_name
FROM information_schema.tables
WHERE table_schema = '数据库名' AND table_name = '表名';

This statement will query the specified database to see if the specified table exists, if it does, it will return the table name, if it doesn’t, it will not return any results.

You can use any of the methods mentioned above to query if a table exists and take appropriate action.

bannerAds