CREATE TABLE musicalartist

CREATE TABLE musicalartist - ('Caramel', 'Caramel Bridges',...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CREATE TABLE musicalartist ( band_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, band_name VARCHAR(20) NOT NULL, members VARCHAR(20) NOT NULL, genre VARCHAR(40) NOT NULL, myspace VARCHAR(80) NOT NULL, website CHAR(40) NOT NULL, facebook CHAR(40) NOT NULL, registration_date DATETIME NOT NULL, PRIMARY KEY (band_id) ); INSERT INTO musicalartist (band_name, members, genre, myspace, website, facebook, registration_date) VALUES ('Maiden Fate', 'Philip Lars, Roger Ring, Luis McCloud', 'Rock', '', '', '', NOW()), ('Wasted Essential', 'Josh Patterson, Nick Moller, Glen Pitts', 'Soft Rock', '', '', '', NOW()), ('Trying Anywhere', 'Harry Mills, Chris Mills, Troy West, Neal Young', 'Rock', '', '', '', NOW()), ('Lil Drill', 'Lil Drill and the Polo Boys', 'Rock', '', '' , '', NOW()),
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ('Caramel', 'Caramel Bridges', 'R&B', '', '', '', NOW()), ('Armadillo', 'Vince Pierce, Tasha Swift, Jerry Rivera, Miranda Cook, Justin Wright', 'Country', '', '', '', NOW()), ('Lockjaw', 'Charles Jones aka Lockjaw', 'Rap', '', '', '', NOW()), ('Swift Wigs', 'Taylor James, Micha Wilson, Chrisy Harris, Jamie Grimes, Jessica Welch', 'Classic Rock', '', '', '', NOW()), ('Nine Leash', 'Navel Swissenson', 'Techno', '', '', '', NOW()), ('Defy', 'Charles Manson, David Goodman, Mark Aguilar, Roy Keller', 'Metal', '', '', '', NOW()), ('Helium of Jupiter', 'Jake Beal, Brandon Shelly, Tony Rojas, Brent Allen', 'Rock', '', '', '', NOW()), ('Punk Belief', 'Travis Dyrdek, Rob Parker, Brad Lopez, George Gonzalez', 'Rock', '', '', '', NOW());...
View Full Document

Page1 / 2

CREATE TABLE musicalartist - ('Caramel', 'Caramel Bridges',...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online