-- Nov 28 In-Class Exercise
Amits-MacBook-Pro:~ amitranganathan$ sqlite3 foo
SQLite version 3.23.1 2018-04-10 17:39:29
Enter ".help" for usage hints.
sqlite> create table R(A INT, B INT DEFAULT 1);
sqlite> insert into R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
sqlite> UPDATE R SET B = A * A;
sqlite> DELETE FROM R WHERE B < 25;
sqlite> UPDATE R SET B = 26 WHERE B = 25;
Amits-MacBook-Pro:~ amitranganathan$ sqlite3 foo
SQLite version 3.23.1 2018-04-10 17:39:29
Enter ".help" for usage hints.
sqlite> create table R(A INT, B INT DEFAULT 1);
sqlite> insert into R(A) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
sqlite> UPDATE R SET B = A * A;
sqlite> DELETE FROM R WHERE B < 25;
sqlite> UPDATE R SET B = 26 WHERE B = 25;