Horla 最近的时间轴更新 Horla 最近的时间轴更新 |
HorlaV2EX 第 193096 号会员，加入于 2016-09-23 10:06:29 +08:00 |
Horla 最近回复了
2019-01-18 10:25:38 +08:00 回复了 Mephisto233 创建的主题 › Python › 在 flask 中使用 pymysql 报错,望大神解答!感激不尽! |
```sql
SELECT user.id AS user_id, user.email AS user_email, user.password AS user_password, user.telephone AS user_telephone, user.username AS user_username, user.`headImageUrl` AS `user_headImageUrl`, user.is_vip AS user_is_vip, user.vip_grade AS user_vip_grade, user.pic_package AS user_pic_package, user.`deadLineTime` AS `user_deadLineTime`, user.`adsID` AS `user_adsID`, user.uuid AS user_uuid, user.creat_time AS user_creat_time, user.login_time AS user_login_time, user.last_login_time AS user_last_login_time, user.vip_id AS user_vip_id \nFROM user ORDER BY false DESC \n LIMIT %(param_1)s'
```
报错信息里有的啊，你的 SQL 里有一段`ORDER BY false DECS`，查询写的不对。
SELECT user.id AS user_id, user.email AS user_email, user.password AS user_password, user.telephone AS user_telephone, user.username AS user_username, user.`headImageUrl` AS `user_headImageUrl`, user.is_vip AS user_is_vip, user.vip_grade AS user_vip_grade, user.pic_package AS user_pic_package, user.`deadLineTime` AS `user_deadLineTime`, user.`adsID` AS `user_adsID`, user.uuid AS user_uuid, user.creat_time AS user_creat_time, user.login_time AS user_login_time, user.last_login_time AS user_last_login_time, user.vip_id AS user_vip_id \nFROM user ORDER BY false DESC \n LIMIT %(param_1)s'
```
报错信息里有的啊，你的 SQL 里有一段`ORDER BY false DECS`，查询写的不对。
Select Language