cur.execute("CREATE TABLE place (city VARCHAR (20))") # 單個字段
cur.execute("CREATE TABLE singer_song (ID inter PRIMARY KEY,singer VARCHAR (20), song_name VARCHAR (20))") # 多個字段
插入資料:
cur.execute('INSERT INTO place (city) VALUES (?)', [i.strip()]) # 插入1個值的資料,後面的值為清單
cur.execute('INSERT INTO singer_song (singer, song_name) VALUES (?, ?)', (i, j))
查找資料:
cur.execute("SELECT song_name FROM mytable where singer_name ='%s'"%name1)
cur.execute("SELECT * FROM place WHERE rowid = 173") # rowid為系統預設的id(每一行前面的id,從1開始)
更新/删除資料:
cur.execute("UPDATE song SET name = ? WHERE ID = ? ", ('周傑倫', 12))
cur.execute("DELETE FROM song WHERE ID = 2 ")