MySql
LI_AINY
这个作者很懒,什么都没留下…
展开
-
MySql批处理
不打开mysql的批处理 @Test public void TestSqlBatch(){ try{ //加载驱动程序 Class.forName("com.mysql.jdbc.Driver"); ...原创 2019-01-18 17:50:57 · 210 阅读 · 0 评论 -
Sql使用distinct关键字去重
建立一个表,新建多条记录,并有列字段重复。查询select DISTINCT str from sb;结果,去掉了重复字段原创 2019-01-19 16:55:28 · 2375 阅读 · 0 评论 -
数据库索引
数据库索引转自http://www.cnblogs.com/aspwebchh/p/6652855.html参考http://www.cnblogs.com/gavinsp/p/5513536.html使用索引很简单,只要能写创建表的语句,就肯定能写创建索引的语句,要知道这个世界上是不存在不会创建表的服务器端程序员的。然而, 会使用索引是一回事, 而深入理解索引原理又能恰到好处使用索引又是另...转载 2019-01-31 11:11:31 · 156 阅读 · 0 评论 -
mysql创建表报错#1166 - Incorrect column name 'UId '
原因:有字段名后台有空格.空格是不能做字段名的.删除空格就行了原创 2019-03-03 15:36:28 · 1433 阅读 · 0 评论 -
Native table 'performance_schema'.'session_variables' has the wrong structure
Native table 'performance_schema'.'session_variables' has the wrong structurecmd’进入mysqlmysql -u root -p执行set @@global.show_compatibility_56=ON;原创 2019-03-09 23:34:54 · 2360 阅读 · 1 评论 -
com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'Öйú±ê׼ʱ
出错代码Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: The server time zone value '�й���ʱ��' is unrecog...原创 2019-03-11 21:38:40 · 1825 阅读 · 0 评论 -
Caused by: com.mysql.cj.exceptions.CJException: The connection property 'useSSL' acceptable values a
报错Caused by: com.mysql.cj.exceptions.WrongArgumentException: The connection property 'useSSL' acceptable values are: 'TRUE', 'FALSE', 'YES' or 'NO'. The value 'false$serverTimezone=UTC' is not acce...原创 2019-03-22 23:11:19 · 9081 阅读 · 0 评论 -
UNION 和 UNION ALL
UNION 查询出的结果如果有相同的,则去重UNION ALL会展示所有结果,不去重原创 2019-04-16 16:41:33 · 156 阅读 · 0 评论 -
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received
重启MySql服务The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at sun.reflect.NativeConstructorAccessorImpl.newInstance0...原创 2019-07-18 10:26:29 · 1074 阅读 · 0 评论