![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
guoweisharp
这个作者很懒,什么都没留下…
展开
-
mysql:ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or RE
MySQL开启bin-log后,调用存储过程或者函数以及触发器时,会出现错误号为1418的错误: ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL,or READS SQL DATA in its declaration and binary logging is enabled(you *might* ...原创 2015-07-09 15:24:26 · 162 阅读 · 0 评论 -
mysql 表按字段去重复
select *,count(distinct userName) from t_doctor group by userName; 这段可以用来去重复,很奇怪,先记下来。然后再自己研究下原创 2016-02-24 15:23:06 · 151 阅读 · 0 评论 -
mysql: 找最大值
要求:获得按table1_id分组,并且age最大的记录信息,即2、3、5条 方法一: select * from (select * from table2 order by age desc) as a group by a.table1_id 方法二: select a.* from table2 as a where age = (select ma...原创 2016-02-24 15:25:31 · 1202 阅读 · 0 评论