#!/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 数据库插入操作
发表于
发表回复