-- buildContactAutoIncrement.sql

DROP TABLE IF EXISTS contact;

CREATE TABLE contact (
  contactID int PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(50),
  company VARCHAR(30),
  email VARCHAR(50)
);

INSERT INTO contact VALUES 
  (null, 'Bill Gates', 'Microsoft', 'bill@msBob.com');
INSERT INTO contact VALUES 
  (null, 'Steve Jobs', 'Apple', 'steve@rememberNewton.com');
INSERT INTO contact VALUES 
  (null, 'Linus Torvalds', 'W3C', 'linus@gnuWho.org');
INSERT INTO contact VALUES 
  (null, 'Andy Harris', 'Wiley Press', 'andy@aharrisBooks.net');

SELECT * FROM contact;