Create a MySQL Table Only if It Doesn't Already Exist

index.md

Create a MySQL Table Only if It Doesn't Already Exist

The following statement creates a MySQL table Products only if it doesn't yet exist. If the table does already exist, then the statement will do nothing.

CREATE TABLE IF NOT EXISTS Products (
  product_id int,
  low_fats ENUM('Y', 'N'),
  recyclable ENUM('Y', 'N')
);