#!/usr/bin/python
# coding:utf-8
import pymysql,os
import time
t = time.time()
print(int(t))
# os._exit(0)
#创建链接
conn = pymysql.connect(host='127.0.0.1',port=3306,user='root',passwd='root',db='pymysql',charset='utf8')
#创建游标
cursor = conn.cursor()
#执行SQL
cursor.executemany('insert into may_test(title,content,time)values(%s,%s,%s)',[("你好","你好啊",t),("早上好","早上好啊",t)])
conn.commit()
cursor.close()
conn.close()
python 数据库插入操作
发表于

发表回复