# -*- coding: utf-8 -*- import mysql.connector # 注意把password设为你的root口令: conn = mysql.connector.connect(user='root', password='933032', database='sxf') cursor = conn.cursor() # 创建user表: cursor.execute('create table usertestd (id int(4) PRIMARY KEY , name varchar(20))') # 插入一行记录,注意MySQL的占位符是%s: cursor.execute('insert into user (id, name) values (%s, %s)', [1, 'Michael']) cursor.rowcount # 提交事务: conn.commit() cursor.close() # 运行查询: cursor = conn.cursor() cursor.execute('select * from user where id = %s', ('1',)) values = cursor.fetchall() print (values) # 关闭Cursor和Connection: cursor.close() conn.close()
mysql(python)
最新推荐文章于 2024-05-19 15:51:39 发布