Create Table

  • CREATE TABLE MyGuests(id INT AUTO_INCREMENT PRIMARY KEY NOT NULL, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, email VARCHAR(50))

DROP Table

  • DROP TABLE MyGuests

ALTER Table

  • ALTER TABLE table_name MODIFY COLUMN column_name datatype
  • ALTER TABLE table_name DROP COLUMN column_name
  • ALTER TABLE table_name ADD COLUMN column_name datatype