Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE CUSTOMERS (
- ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
- FIRST_NAME VARCHAR(20),
- LAST_NAME VARCHAR(30),
- ADDRESS VARCHAR(30),
- CITY VARCHAR(30),
- STATE_ VARCHAR(30),
- ZIP VARCHAR(15),
- COUNTRY_ID INTEGER,
- PHONE VARCHAR(15),
- EMAIL_ADDRESS VARCHAR(50)
- )ENGINE=INNODB;
- CREATE TABLE CUSTOMERS
- ( ID INTEGER NOT NULL auto_increment,
- FIRST_NAME VARCHAR(20),
- LAST_NAME VARCHAR(30),
- ADDRESS VARCHAR(30),
- CITY VARCHAR(30),
- STATE_ VARCHAR(30),
- ZIP VARCHAR(15),
- COUNTRY_ID INTEGER,
- PHONE VARCHAR(15),
- EMAIL_ADDRESS VARCHAR(50),
- PRIMARY KEY (ID));
Add Comment
Please, Sign In to add comment