基本操作:
import pymysql #导入模块
conn =pymysql.connect(
host ='127.0.0.1',
port =3307,
user ='root',
passwd='xhdake',
db ='CSRF',
charset ='utf8',
)
#建立游标
cursor =conn.cursor()
#(开始)操作数据库
rab =cursor.execute('SELECT * FROM "sqlite_sequence"') #输入数据库语句
data =cursor.fetchone() #返回单个元组
data =cursor.fetchall() #返回多个元组
print(rab)
conn.close() #关闭数据库
------------------------------------------------------------------------------
新增数据库:
方法一:(1)添加单条数据
def xinz():
sql ="""INSERT INTO sqlite_sequence(name,seq)VALUES('abc',245)"""#
cursor.execute(sql)
conn.commit()
conn.close() #关