连接数据库:
1 2 3 4 5 6 7 8 9 10 |
import pymysql conn = pymysql.connect( host = "localhost", user = "root", password = "123456", database = "python_database", port = 3306 ) cursor = conn.cursor() |
insert操作:
第一种方法:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
import pymysql conn = pymysql.connect( host = "localhost", user = "root", password = "123456", database = "python_database", port = 3306 ) cursor = conn.cursor() #创建游标对象 sql = 'insert into test(name,age,country) values("jack",20,"country")' cursor.execute(sql) #执行sql语句 conn.commit() #想让insert 语句 插入数据库里面去需要加上这个 cursor.close() conn.close() |

第二种方法:
1 2 3 4 5 6 7 |
sql = 'insert into test(name,age,country) values(%s,%s,%s)' #不管mysql里面的类型是什么,在这个python语法中都是%s来代表稍后传参数 name = "rose" age = 30 country = "france" cursor.execute(sql,(name,age,country)) #在执行的sql语句后面,通过元组来传递具体的数据 |
