Skip to content

Instantly share code, notes, and snippets.

@claraj
Created April 14, 2016 15:13
Show Gist options
  • Save claraj/30882cbae61fe0143a562ec284777dcd to your computer and use it in GitHub Desktop.
Save claraj/30882cbae61fe0143a562ec284777dcd to your computer and use it in GitHub Desktop.
create database animals;
use animals;
create table dogs (name varchar(30), age int, weight double, vaccinated boolean);
insert into dogs values ('Tilly', 4, 20, true);
insert into dogs values ('Poppy', 1, 24, false);
insert into dogs values ('Zelda', 4, 35, true);
insert into dogs values ('Einstein', 10, 40, false);
insert into dogs values ('Snoopy', 3, 10, true);
select * from dogs;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment