MySql
破军_七杀
这个作者很懒,什么都没留下…
展开
-
MySQL 报错:Parameter ‘@XXX‘ must be defined.
报错信息:Parameter ‘@Name’ must be defined.解决方案:连接语句中添加:allowuservariables=True; 即可配置解析:AllowUserVariables:是否允许 SQL 中出现用户变量,默认 false原创 2021-05-28 22:22:29 · 3557 阅读 · 0 评论 -
mysql group by和order by 同时使用获取最新一条数据不同版本的写法
MySql 5.5版写法select * from (select * from table_name order by create_time desc) as t group by t.id;MySql 5.7版写法select * from (select * from table_name order by create_time desc limit 100000) as t group by t.id;原创 2021-05-28 22:20:28 · 216 阅读 · 0 评论