![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
--LIANG--
愿你出走半生,归来仍是少年。
展开
-
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
在执行一段SQL时出现以下问题[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mo原创 2021-05-12 10:23:31 · 457 阅读 · 0 评论 -
mysql大批量更新数据
大批量的更新数据如果再使用传统的(update)方法一条一条的更新,效率是很慢的,而且性能差,也很容易造成阻塞。这里给大家分享两种方法:1:使用mysql 自有的语句构建批量更新 UPDATE tble SET price = CASE id WHEN 16 THEN 7.6 WHEN 19 THEN 8.86 WHEN 20 THEN 9 END WHERE id IN (1原创 2017-05-18 15:04:56 · 7569 阅读 · 0 评论 -
execute immediate v_sql用法
execute immediate v_sql用法: 例: create or replace procedure proc_test( –参数区域 ) is –变量区域 –sql脚本 v_sql varchar2(2000) :=”; –记录学生数量 v_num number; begin –执行区域-- execute immediate原创 2017-11-25 22:34:27 · 8477 阅读 · 0 评论