· 7 years ago · Jan 19, 2019, 05:18 PM
1DROP DATABASE xxx; # will delete the whole database
2DROP TABLE xxx; # unconditionally deletes a table
3CREATE TABLE [IF NOT EXISTS] # if IF NOT EXISTS adds the table, does nothing if exists
4 # otherwise, it adds the table, gives an error if it exists