MySQL stored procedure detects if a table exists

SQL Statement implementation:

SELECT COUNT (*) from INFORMATION_SCHEMA. ' TABLES ' WHERE table_name= ' youtablename ';

In the WHERE clause, the table name is a string type, and the single quotation mark is added.

In the MySQL stored procedure

Function implementation:

CREATE definer = ' root ' @ ' localhost ' FUNCTION ' tableexists ' (' tname ' varchar ()) RETURNS tinyint (4) Begindeclare Tableexists TINYINT DEFAULT 0; SELECT 1 to Tableexists from INFORMATION_SCHEMA. ' TABLES ' WHERE table_name=tname; RETURN tableexists; END;

MySQL stored procedure detects if a table exists