How to check if table exist in mysql

Question

How to check if table exits in mysql

Answer 1

https://stackoverflow.com/questions/1717495/check-if-a-database-table-exists-using-php-pdo#:~:text=Once%20you%20have%20your%20database,wrap%20it%20in%20a%20function.

Answer 2

By using the command "SHOW TABLES" in the known database.
OR
SELECT *FROM Table2. (where Table2 is the table whose existence u want to check.)
OR
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = '[database name]' AND table_name = '[table name]';

Answer 3

Shariff Wlcm.

Answer 4

For show all tables ==> Show tables ;
Or
For search by name ==> show tables like 'yourTableName';

Answer 5

Alphin K Sajan how will you execute this from PDO

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

will this return Boolean ? and can we execute this query in PDO?

Answer 6

Thanks, it was helpful , let me check it out