mysql.connector-通过ID降序排序

import mysql.connector
conn= mysql.connector.Connect(
    host='localhost',
    user='root',
    passwd='admin',
    database='testcode'
)
print('1.',conn)
cmd = conn.cursor()  # 光标行
cmd.execute('select * from test where id>0 order by id desc')
print('6.',cmd.fetchall())

 

posted @ 2020-08-15 17:30  cy583  阅读(188)  评论(0编辑  收藏  举报