Skip to content

Instantly share code, notes, and snippets.

@samueldowens
Created September 24, 2013 23:59
Show Gist options
  • Save samueldowens/6693057 to your computer and use it in GitHub Desktop.
Save samueldowens/6693057 to your computer and use it in GitHub Desktop.
first sql homework
CREATE TABLE artists(
worstbandname TEXT,
fartsperday INTEGER
);
ALTER TABLE artists ADD COLUMN instrument TEXT;
DROP TABLE artists;
CREATE TABLE artists(
worstbandname TEXT,
fartsperday INTEGER
);
ALTER TABLE artists RENAME TO musicians;
DROP TABLE musicians;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment