Python-MySQL-2

来源:互联网 发布:linux less命令 退出 编辑:程序博客网 时间:2024/06/10 12:05
#!/usr/bin/pythonimport MySQLdbimport timeconn = MySQLdb.connect(host='localhost',user='root',passwd='123456',charset='utf8')cursor = conn.cursor()conn.select_db('db-yjx');cdate = time.strftime('%Y-%m-%d %H:%M:%S',time.localtime(time.time()))value = [cdate, 1, 2];cursor.execute("insert into t11(cdate, c2, c3) values(%s, %s, %s)",value);cursor.close()conn.commit()conn.close()


0 0
原创粉丝点击