· 8 years ago · Dec 04, 2017, 07:00 PM
1CREATE TABLE IF NOT EXISTS `customers` (`CustomerID` INT AUTO_INCREMENT,
2`FirstName` VARCHAR(255) NOT NULL,
3`LastName` VARCHAR(255) NOT NULL,
4`Address` VARCHAR(255) NOT NULL,
5`Apt#` VARCHAR(255) NOT NULL,
6`City` VARCHAR(50) NOT NULL,
7`State` VARCHAR(3) NOT NULL,
8`Zip` VARCHAR(9) NOT NULL,
9`HomePhone` VARCHAR(11),
10`MobilePhone` VARCHAR(11),
11`OtherPhone` VARCHAR(11),
12PRIMARY KEY(`CustomerID`)
13)
14ENGINE=INNODB;
15INSERT INTO `customers` VALUES