Answers for "IF TABLE EXISTS mysql"

mysql check table exists

SELECT *  FROM information_schema WHERE TABLE_NAME = "my_table"

Posted by: Guest on May-15-2021

mysql create table if not exists

CREATE TABLE [IF NOT EXISTS] table_name(
   column_1_definition,
   column_2_definition,
   ...,
   table_constraints
) ENGINE=storage_engine;

Posted by: Guest on October-14-2020

Code answers related to "IF TABLE EXISTS mysql"