SQL命令（插入、修改、删除、查询）

cursor.execute (带参数的SQL命令, (参数列表))

插入命令：

sql = "insert into students (sNo,sName,sChinese,sMath,sEnglish) values (%s,%s,%s,%s,%s)"
cursor.execute(sql,[sNo,sName,sChinese,sMath,sEnglish])

调试过程出现的问题：忘记加“，”

sql = "insert into students (sNo,sName,sChinese,sMath,sEnglish) values (%s %s %s %s %s)"

修改命令：

 sql = "update students set sName=%s,sChinese=%s,sMath=%s,sEnglish=%s where sNo=%s"
 cursor.execute(sql,[sName,sChinese,sMath,sEnglish,sNo])

调试过程出现的问题：参数列表顺序错误

 sql = "update students set sName=%s,sChinese=%s,sMath=%s,sEnglish=%s where sNo=%s"
 cursor.execute(sql,[sNo,sName,sChinese,sMath,sEnglish])

删除命令:

sql = "delete from students where sNo=%s"
cursor.execute(sql,[sNo])

查询命令：

sql = "select * from students order by sNo"
            cursor.execute(sql)
            rows = cursor.fetchall()
            for row in rows:
                print("%s%s%d%d%d" %(row["sNo"],row["sName"],row["sChinese"],row["sMath"],row["sEnglish"]))