python - 如何选择和删除数据库的第一行？

Question

这是我的代码:

db = MySQLdb.connect("localhost", "root", "raspberry", "cribdb")
curs=db.cursor()

curs.execute ("""INSERT INTO tbstatus values(NOT NULL, 'status')""")

db.commit()

number_of_rows= curs.execute("SELECT * FROM tbstatus")

if (number_of_rows <= 5):

    print(number_of_rows)
else:

    curs.execute("""SELECT * from tbstatus""")

    row1=curs.fetchone()

    db.commit()

    curs.execute("""Delete from tbstatus where id = 'row1'""")

    db.commit()

    print("\n Record Deleted successfully ")

没有错误，但删除功能不起作用。我只想在达到最大限制(5)后删除数据库的第一行。我该怎么办？谢谢!

Answer 1

尝试用limit代替ID

curs.execute("""DELETE FROM tbstatus order by id LIMIT 1""")