Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save jcharles22/bc7bbe58bcc69f4d75826c307388b510 to your computer and use it in GitHub Desktop.
Save jcharles22/bc7bbe58bcc69f4d75826c307388b510 to your computer and use it in GitHub Desktop.
intro to sql assiment
drop table if exists bookmarks;
CREATE table bookmarks (
id primary key ,
title text not null,
rating INTEGER not null,
description text not null,
url text not null,
imgUrl text,
submittedBy text,
submittedDate,
comments text,
costToUse text
);
insert into bookmarks (description, id, rating, title, url)
values
(
"Think outside the classroom",
"4f66488b-2b57-4613-a07f-57ab3b53e92c",
5,
"Thinkful",
"https://www.thinkful.com"
),
(
"Where we find everything else",
"73cce592-d75e-48c9-abc1-b7041b31cd60",
4,
"Google",
"https://www.google.com"
),
(
"The only place to find web documentation",
"563b324e-d873-428f-bff8-da0033b7f0f2",
5,
"MDN",
"https://developer.mozilla.org"
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment