数据的删除
sql语句中delete from 表名 where 条件
import sqlite3
conn = sqlite3.connect('study.db')
cur = conn.cursor()
sql = '''delete from company where company.salary>5000'''
cursor = cur.execute(sql) # 查询会返回一个值
# cur.execute('drop table company') # 删除整张表
conn.commit()
conn.close()
print('删除数据完毕')
原表:
删除后:
数据的查询:
sql语句中:select 查询元素 from 表名 where 条件
import sqlite3
# 查询数据整行及满足条件的查询, '*'可代值全部类别
conn = sqlite3.connect('study.db')
cur = conn.cursor()
sql = '''select id,name,age,address,salary from company where company.salary>5000'''
cursor = cur.execute(sql) # 查询会返回一个值
# sql = '''select * from company where company.salary>4000'''
# cursor = cur.execute(sql) # 查询会返回一个值
for row in cursor:
print(row) # 要查询某一元素row[i],i 从0开始
conn.close()
print('查询数据完毕')
数据的改变:
sql语句中:update company set 要改的元素 where 条件
import sqlite3
conn = sqlite3.connect('study.db')
cur = conn.cursor()
sql = '''
update company set age=?,salary =? where id = ?
'''
cur.execute(sql, (30, 10000, 1)) # 对多行数据进行插入
conn.commit()
conn.close()
运行后:改变了id为1的那一行
本人新手,若有错误,谢谢指正