Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP DATABASE IF EXISTS addressBook;
- CREATE DATABASE addressBook;
- USE addressBook;
- CREATE TABLE contact (
- id INT NOT NULL AUTO_INCREMENT,
- firstName VARCHAR(30) NOT NULL,
- lastName VARCHAR(30),
- email VARCHAR(30),
- phoneNo VARCHAR(13),
- PRIMARY KEY(id)
- );
- INSERT INTO contact VALUES (
- DEFAULT,
- 'Michael',
- 'Taylor',
- 'michael@abc.com',
- "+919876543210"
- );
- INSERT INTO contact VALUES (
- DEFAULT,
- 'William',
- 'Becker',
- 'william@abc.com',
- '+449876543210'
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement