Python连接mysql

如下：

导入pymysql包就可以，

import pymysql      #python3使用这个包连接mysql

db = pymysql.connect('localhost','root','123456','testmysql')   #连接数据库地址、账户、密码、database

cursor = db.cursor()    #cursor方法得到操作对象

cursor.execute('select version()')  #执行SQL语句

sql = 'select * from employee'

cursor.execute(sql)
sql1 = 'insert into employee (id,name,salary,departmentid) values (8,"s8",20043,2)'      #values后面的非数字的值必须要用“ ”双引号

sql2 = 'create table python_connect(id int primary key auto_increment,name varchar(11))'
sql3 = 'insert into python_connect (id,name)values (1,"yx")'    #为什么insert无效?

sql4 = 'update python_connect set name = "xx" where id = 1'

combine = (sql3,sql4)

sql5 = 'delete from python_connect where id = 1'
cursor.execute(sql2)

# 使用excutemany()执行多条语句
tmp = "insert into exch_no_rand_auto(stkcode) values(%s);"   #SQL模板字符串
l_tupple = [(i,) for i in range(100)]   #生成数据参数，list里嵌套tuple
cursor.executemany(tmp,l_tupple)


for i in combine:       #excutemany()方法可以执行多条语句，但是必须每条语句的形式一致，不一致的就用for吧
    cursor.execute(i)

db.commit()     #insert、update、delete语句需要commit()提交才能执行,但是select不需要,因为增删改都会对表进行改变，查不会


data = cursor.fetchone()    #fechone方法返回一条记录
data = cursor.fetchall()    #fetchall 返回所有记录
data = cursor.fetchmany(2)  #fetchmany 返回指定条记录

print(data)
print(type(data))       #返回的是tuple元组类型数据
db.close()