Python基础知识25（# # mysql 操作）

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