# mysql 操作
# import mysql.connector
# # pip install mysql-connector
# # 链接mysql
# # conn = mysql.connector.connect(
# # host="192.000.00.000",
# # user="23124",
# # password="14124"
# # )
# # print(conn)
# conn = mysql.connector.connect(
# # host="192.000.00.000",
# # user="23124",
# # password="14124"
# database="family"
# )
# cursor = conn.cursor()
# 创建 cursor
# cursor = conn.cursor()
# data_name = 'family'
# sql = f"create database {data_name}"
# cursor.execute(sql)
# 创建表
# cursor = conn.cursor()
# sql = "create table user(id int auto_increment primary key,name varchar(20),classname varchar(255))"
# cursor.execute(sql)
# 插入数据到表
# sql = "insert into user(name,classname)values(%s,%s)"
# svalue = ('wangjiangbo', '0630')
# cursor.execute(sql, svalue)
# conn.commit() #别忘了 commit
# # 查询
# sql = "select * from user where id='3'"
# cursor.execute(sql)
# res = cursor.fetchall()
# print(res)
# 删除
# sql = "delete from user where id='3'"
# cursor.execute(sql)
# conn.commit()
# 修改
# sql = "update user set name = 'qianqianxueyan' where id='5'"
# cursor.execute(sql)
# conn.commit()
# pip install pymysql
import pymysql
conn = pymysql.connect(
host="192.000.00.000",
user="23124",
password="14124"
database="family"
)
cursor = conn.cursor()
cursor.execute('select * from user')
# data = cursor.fetchall()
# data = cursor.fetchone()
data = cursor.fetchmany(3)
print(data)