Newer
Older
VALUES (NULL, 'Michael','Jackson'),(NULL, 'Taylor','Swift'),
(NULL, 'Jiyong','Kwon'),(NULL, 'Bruno','Mars'),
(NULL, 'Rick','James'),(NULL, 'Kanye','West'),
(NULL, 'Justin','Timberlake'),(NULL, 'Iggy','Azelea'),
(NULL, 'Pharell','Williams'),(NULL, 'Bob','Marley'),
(NULL, 'Phil','Collins'),(NULL, 'Sam','Smith'),(NULL, 'Janet','Jackson');
INSERT INTO record( title, artist_id, genre, year, price)
VALUES ('Thriller',1,'Pop',1983,4.95),
('Bad Blood',2,'Pop',2014,3.99),
('22',2,'Pop',2012,3.99),
('One of a kind',3,'K-Pop',2012,3.99),
('Treasure',4,'Pop',2012,4.99),
('Give it to me baby',5,'Funk',1981,5.17),
('Stronger',6,'Hip-Hop',2007,5.92),
('Cry me a river',7,'RnB',2002,2.99),
('Trouble',8,'Pop',2014,2.49),
('Happy',9,'Pop',2014,3.26),
('Three little birds',10,'Reggae',1977,3.99),
('In the air tonight',11,'Rock',1981,2.10),
('Rhythm Nation',13,'Pop',1989,3.10),
('Stay with me',12,'Soul',2014,1.99);
INSERT INTO customer(id, first_name, last_name, dob, email_address, address_1, address_2, postcode)
VALUES (NULL, 'Tracy','Fu', '1985-08-27','t.fu85@gmail.com','34 Oldview Court','London','SW4 6PT'),
(NULL, 'Jennifer','Brunning', '1973-03-03','jennbrunning@hotmail.com','16b Olgar Close','Swansea','SA1 3SD'),
(NULL, 'Stephen','Mak', '1990-02-01','mastermak@live.co.uk','22 Parkerview Road', 'Brighton','BN2 4RG'),
(NULL, 'Rebecca','Kurtz', '1965-09-15','kurtz.rebecca@yahoo.co.uk','13 Ascot Drive', 'Hertfordshire','SG14 6DC'),
(NULL, 'Leah','Jones', '1994-08-01', 'jones1894@hotmail.co.uk', '64 Perryside Road', 'Manchester','M11 3RT'),
(NULL, 'Louise','Pearson', '1982-03-07', 'louiseboo@gmail.com', '1 Chertsy Grove', 'Luton','LU7 9QB'),
(NULL, 'Shannon','Sullivan', '1977-09-04', 'mrs.sullivan@yahoo.com', '19 Bayford Road','London','NW10 5DJ'),
(NULL, 'Chris','Fu', '1986-11-23', 'christofu@live.co.uk', '66 Algernon Road', 'Manchester', 'M16 8GB'),
(NULL, 'Felix','Channing', '1988-12-16', 'felix.1612@btinternet.com', '23 Talbot Drive','Liverpool','L13 8HB'),
(NULL, 'Oscar','Jones', '1995-10-30', 'player.jones@gmail.com', '75 Osram Court','London','W6 7PF' );
INSERT INTO transaction (id, customer_id, delivery_method, order_date)
VALUES (NULL, 1,1,'2015-10-03 11:34:15'),
(NULL, 1,1,'2015-10-03 11:38:35'),
(NULL, 9,2,'2015-10-08 01:08:18'),
(NULL, 2,2,'2015-10-07 09:06:42'),
(NULL, 4,1,'2015-10-01 08:43:32'),
(NULL, 6,1,'2015-10-25 15:19:20'),
(NULL, 4,1,'2015-10-22 16:28:28'),
(NULL, 1,2,'2015-10-16 12:20:39'),
(NULL, 2,1,'2015-10-19 10:14:46'),
(NULL, 8,2,'2015-10-20 10:13:21'),
(NULL, 7,1,'2015-10-20 19:17:20'),
(NULL, 3,1,'2015-10-21 02:54:16'),
(NULL, 10,2,'2015-10-24 20:39:12'),
(NULL, 1,2,'2015-10-25 23:10:08'),
(NULL, 5,2,'2015-10-26 00:14:03'),
(NULL, 2,1,'2015-10-29 15:18:39'),
(NULL, 8,3,'2015-10-30 11:52:44');