Check if exist in MySQL

2 years ago
Benjamin Taylor
1 minute

In MySQL, you can determine whether a table, database, column, or stored procedure exists using the following methods:

  1. Check if the table exists.
SELECT *
FROM information_schema.tables
WHERE table_schema = 'your_database_name'
  AND table_name = 'your_table_name';

If the query result is empty, then the table does not exist.

  1. Check if the database exists.
SHOW DATABASES LIKE 'your_database_name';

If the query returns nothing, the database does not exist.

  1. Check if the column exists.
SELECT *
FROM information_schema.columns
WHERE table_schema = 'your_database_name'
  AND table_name = 'your_table_name'
  AND column_name = 'your_column_name';

If the query result is empty, the column does not exist.

  1. Check if the stored procedure exists.
SHOW PROCEDURE STATUS WHERE Name = 'your_procedure_name';

If the query result is empty, then the stored procedure does not exist.

The above method allows for choosing an appropriate way to determine the existence of an object based on the needs.

bannerAds