K12教育赛事综合服务平台
专注青少年竞赛题库网站
聚乐之家官方网站
下载聚乐之家官方App
在图书馆管理系统中,已知书籍列表:new_books = [('Book 1', 'Author 1'), ('Book 2', 'Author 2')],需要将列表中所有书籍信息插入到books表中。
new_books = [('Book 1', 'Author 1'), ('Book 2', 'Author 2')]
import sqlite3 conn = sqlite3.connect('library.db') cursor = conn.cursor() cursor.executemany('INSERT INTO books (title, author) VALUES (?, ?)', new_books) conn.commit() conn.close()
import sqlite3 conn = sqlite3.connect('library.db') cursor = conn.cursor() cursor.execute('INSERT INTO books (title, author) VALUES (?, ?)', new_books) conn.commit() conn.close()
import sqlite3 conn = sqlite3.connect('library.db') cursor = conn.cursor() cursor.executemany('INSERT INTO books (title, author) VALUES (?, ?)', new_books[0]) conn.commit() conn.close()
import sqlite3 conn = sqlite3.connect('library.db') cursor = conn.cursor() cursor.execute('INSERT INTO books (title, author) VALUES (?, ?)', new_books[0]) conn.commit() conn.close()