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 ")