code_junkie

auto_increment causing errors with CREATE TABLE

Nov 12th, 2011
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. CREATE TABLE CUSTOMERS (
  2. ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
  3. FIRST_NAME VARCHAR(20),
  4. LAST_NAME VARCHAR(30),
  5. ADDRESS VARCHAR(30),
  6. CITY VARCHAR(30),
  7. STATE_ VARCHAR(30),
  8. ZIP VARCHAR(15),
  9. COUNTRY_ID INTEGER,
  10. PHONE VARCHAR(15),
  11. EMAIL_ADDRESS VARCHAR(50)
  12. )ENGINE=INNODB;
  13.  
  14. CREATE TABLE CUSTOMERS
  15. ( ID INTEGER NOT NULL auto_increment,
  16. FIRST_NAME VARCHAR(20),
  17. LAST_NAME VARCHAR(30),
  18. ADDRESS VARCHAR(30),
  19. CITY VARCHAR(30),
  20. STATE_ VARCHAR(30),
  21. ZIP VARCHAR(15),
  22. COUNTRY_ID INTEGER,
  23. PHONE VARCHAR(15),
  24. EMAIL_ADDRESS VARCHAR(50),
  25. PRIMARY KEY (ID));
Add Comment
Please, Sign In to add comment