python连接数据库

import time<br>from sys import path<br>path.append(r‘C:\Users\Administrator\ceshi1111\Lib\site-packages\pymysql‘)<br>import pymysql<br>from pymysql import *<br><br>db = pymysql.connect(‘192.168.137.9‘,"root","123123","mysql")   #:调用pymysql.connect方法 并输入数据库的信息<br>cursor = db.cursor()        #:调用db中的cursor类<br>cursor.execute("insert into test1 values(‘1‘);") #:sql语句<br>db.commit()         #:提交事务<br>date = cursor.fetchall()<br>db.close()      #:关闭连接

python连接数据库

标签：连接数   insert   pytho   commit   方法   package   sql语句   提交   values