CREATE TABLE friends ( id INTEGER, name TEXT, birthday DATE ); INSERT INTO friends (id,name, birthday) VALUES (1,'Ororo Munroe', 'May 30th, 1940'); INSERT INTO friends (id,name, birthday) VALUES (2,'Edward Nylander', 'July 30th, 1958'); INSERT INTO friends (id,name, birthday) VALUES (3,'Taylor Olson', 'February 20th, 1958'); UPDATE friends SET name = 'Storm' WHERE id = 1; ALTER TABLE friends ADD email TEXT; UPDATE friends SET email = 'storm@codeacademy.com' WHERE id = 1; UPDATE friends SET email = 'randomnumber@mst.edu' WHERE id = 2; UPDATE friends SET email = 'manimissmydawgs@gmail.com' WHERE id = 3; --DELETE FROM friends --WHERE id = 1; SELECT * FROM friends;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter