Creating MySQL Data Tables

Sample Table Customers

CREATE TABLE customers(
   id INT NOT NULL AUTO_INCREMENT,
   fname VARCHAR(200) NOT NULL,
   lname VARCHAR(200) NOT NULL,
   email VARCHAR(200) NOT NULL,
   phone VARCHAR(200) NOT NULL,
   address VARCHAR(200) NOT NULL,
   PRIMARY KEY ( id )
);