Python 資料庫入門
Jason Myers
Co-Author of Essential SQLAlchemy and Software Engineer
values_list = [] for row in csv_reader: data = {'state': row[0], 'sex': row[1], 'age': row[2], 'pop2000': row[3], 'pop2008': row[4]} values_list.append(data)
from sqlalchemy import insert stmt = insert(employees) result_proxy = connection.execute(stmt, values_list) print(result_proxy.rowcount)
from sqlalchemy import insert
stmt = insert(employees)
result_proxy = connection.execute(stmt, values_list) print(result_proxy.rowcount)
2
Preparing Video For Download...
