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 · 166 阅读 · 0 评论 -
mysql 表按字段去重复
select *,count(distinct userName) from t_doctor group by userName; 这段可以用来去重复,很奇怪,先记下来。然后再自己研究下原创 2016-02-24 15:23:06 · 155 阅读 · 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 · 1211 阅读 · 0 评论