数据库
sql语句 数据库优化方面的知识
我们都有光明的未来@
这个作者很懒,什么都没留下…
展开
-
MySql和Oracle批量插入
mySqlxml文件中 <insert id="insertBatch" parameterType="java.util.List"> insert into 表名 (column1, column2,column3,column4) values <foreach collection="list" item="Model" separator="," > (原创 2021-03-03 16:00:12 · 177 阅读 · 1 评论 -
ONLY_FULL_GROUP_BY
问题:[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 ...原创 2020-02-24 19:19:46 · 181 阅读 · 1 评论 -
useSSL
控制台报错Mon Feb 24 14:13:52 CST 2020 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+,5.6.26+ and 5.7.6+ requirements SSL connecti...原创 2020-02-24 16:00:39 · 838 阅读 · 0 评论