;
exit
.
;
.exit
.open leegman.db
.help
.databases
.open .leegman.db
.open leegman.db
.tables
.quit
.open leegman.db
.databases
.tables
.open main
.databases
.schema
.use 0
.open /app/leegman.db
.exit
.open /app/leegman.db
.open /leegman.db
.open leegman.db
.databases
.open leegman.db
.databases
.tables
.open ./leegman.db
.open ./.data/leegman.db
.open .data/leegman.db
quit
;
.exit
open leegman.db
;
.open leegman.db
.open leegman.db;
.databases
.open leegman.db
.exit
.open leegman.db
SELECT id, time, t.name teamname from Shots INNER JOIN Teams t on t.id = Shots.teamId WHERE p.gameId = 1 ORDER BY id DESC LIMIT 10
;
.tables
.exit
.open leegman.db
.tables;
.tables
.open leegman.db
ls
;
.tables
.exit
.open leegman.db
.tables
select * from Teams
;
.exit
.open leegman.db
.tables
exit;
exit
.
;
.exit
.open leegman.db
select * from Teams;
update Game set hometeamid = 2, awayteamid = 3 where id = 63;
update Games set hometeamid = 2, awayteamid = 3 where id = 63;
update Games set hometeamid = 4, awayteamid = 1 where id = 64;
select * from Goals where gameid = 61;
update Goals set scoredby = 82, assist1 = 80 where id = 534;
q!
;
q;
quit
;
exit;
!quit
;
!tables;
exit;
.exit
.open leegman.db
select * from Games where seasonid = 14;
q!
;
quit
;
.exit
.quit
.open leegman.db
.tables
select * from Games;
update Games set time = '6/28/2025 9:30' where id = 1016;
update Games set date = '6/28/2025 9:30' where id = 1016;
update Games set date = '6/28/2025 10:45' where id = 1017;
update Games set date = '6/28/2025 12:00' where id = 1018;
.quit
