Skip to content
Snippets Groups Projects
dummy_data.sql 2.85 KiB
Newer Older
Angela Pham's avatar
Angela Pham committed
INSERT INTO artist (id, first_name, last_name)

        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');
Angela Pham's avatar
Angela Pham committed



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');