1、下載http://dev.MySQL.com/downloads/connector/python/

.png)

import mysql.connectorconfig={'host':'127.0.0.1',#默認127.0.0.1 'user':'root', 'passWord':'123456', 'port':3306 ,#默認即為3306 'database':'school_data', 'charset':'utf8'#默認即為utf8 }try: cnn=mysql.connector.connect(**config); PRint("連接成功"); cour=cnn.cursor(); value=('1211','asddd'); sql="""insert into dw (dwdm,dwmc) values (%s,%s)"""; cour.execute(sql,value); #以下這一句很關鍵我少了這一句導致不報錯,也插不進去數據,崩潰呀~~~ cnn.commit();except mysql.connector.Error as e: print('connect fails!{}'.format(e)) finally: cour.close(); cnn.close();
新聞熱點
疑難解答