python串連mysql

標籤：

import pymysqlimport randomconn = pymysql.connect(host =‘127.0.0.1‘,user =‘lick‘,passwd=‘123456‘,db=‘pythontest‘)#建立串連print(conn)for i in range(1,10000):    idm = random.randint(1000,10000)    name = "test"+str(idm)    cur = conn.cursor()#建立遊標，以遊標為基本執行sql語句    cur.execute("show tables")#執行sql語句    sql = "insert into tb01 values(%d,‘%s‘);"%(idm,name)    cur.execute(sql)    cur.execute("select * from tb01")    conn.commit()#提交sql語句到databaseret = cur.fetchall()#擷取語句執行的資訊print(ret)for x in ret:    print(x)cur.close()conn.close()

 

python串連mysql