Python connection MySQL

ImportPymysqlImportRandomconn= Pymysql.connect (host ='127.0.0.1', user ='Lick', passwd='123456', db='pythontest') #建立连接Print(conn) forIinchRange (1,10000): IDM= Random.randint (1000,10000) name="Test"+str (IDM) cur=conn.cursor () #建立游标, a cursor is the basic execution SQL statement 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) forXinchret:Print(x) cur.close () conn.close ()

Python connection MySQL