Skip to content

Instantly share code, notes, and snippets.

@NICKSAUNDERS

NICKSAUNDERS/sqlite

Created November 18, 2020 10:32
Show Gist options
  • Save NICKSAUNDERS/a8257fbee014f265bc6f40c6431b0b9e to your computer and use it in GitHub Desktop.
Save NICKSAUNDERS/a8257fbee014f265bc6f40c6431b0b9e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sqlite
sqlite>
sqlite> select * from lab limit 3;
2020-01-23,"BC",2,2,0,32
2020-01-23,"Fraser",0,0,0,0
2020-01-23,"Interior",0,0,0,0
sqlite>
sqlite> .schema
CREATE TABLE lab(
"Date"",""Region"",""New_Tests"",""Total_Tests"",""Positivity"",""Turn_Around" TEXT
);
sqlite>
sqlite> select "Region" from lab limit 3;
Region
Region
Region
sqlite>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment