python3访问数据库

import pymysql
db = pymysql.Connect(
    host='XXXXXXXX.com',

    user='XXX',
    passwd='XXX',
    db='db_test',  #表名
    charset='utf8'
)

cursor=db.cursor()
str="INSERT INTO `the_XXXX` (`XXX`, `XXX`) VALUES (333323, NULL)"
try:
    cursor.execute(str)
    db.commit()
except:
     db.rollback()
     print("失败")

db.close()

 上面是插入数据

cursor=db.cursor()
str="create table test(testname char(10),testnum int) "
try:
    cursor.execute(str)
    db.commit()
except:
     db.rollback()
     print("失败")

db.close()

上面是新建表

cursor=db.cursor()
str="select * from XXXX"
try:
    cursor.execute(str)
    db.commit()
    results=cursor.fetchall()
    for row in results:
        print(row)
except:
     db.rollback()
     print("失败")

db.close()

上面是查询

输入变量的话，就是将变量放进字符串，然后其他逻辑都一样，没什么跟python操作不一样的

 

转载于:https://www.cnblogs.com/mghhzAnne/p/10510402.html