Databases method of tables create and drop tables 🤓 1 2 create table numbers (n, note); create table numbers (n UNIQUE, note DEFAULT 'unknown'); 1 drop table if exists t; insert data into tables 1 2 insert into t values (1, 'one'); insert into t(col1) values (2); update 1 update t set col1 = 3 where col2 = 'two'; delete 1 delete from t where col1 = 1; Python and SQL 1 2 3 4 5 6 7 8 9 10 11 import sqlite3 # connect to the database conn = sqlite3.

Aggregation see here

Tables Joining Tables 见CS186 重点从eval / SICP 角度看语句是如何被eval的 Strings methods