mysql
haoyuxingchenX
逆水行舟,不进则退
展开
-
navicat 导入文件 3个选项灰色
导入时设置主键后就好了原创 2020-09-14 15:46:55 · 1770 阅读 · 0 评论 -
mysql插入数据
https://www.cnblogs.com/Tpf386/p/11851002.html原创 2020-07-16 11:37:37 · 172 阅读 · 0 评论 -
SQL的各种连接Join详解
https://www.cnblogs.com/reaptomorrow-flydream/p/8145610.html原创 2020-07-06 12:57:45 · 451 阅读 · 0 评论 -
mysql事务使用
mysql使用事务写法:# 默认mysql开启了自动提交,在执行insert,update,delete语句时候每一条sql语句就是一个事务。# 查看自动提交show global variables like 'autocommit';关闭自动提交:set global autocommit=0;开启:set global autocommit=1;操作:# 开启事务begin; 或:start transaction;# 回滚注:回滚后,事务结...原创 2020-07-03 10:23:02 · 148 阅读 · 0 评论 -
java.sql.SQLException: The server time zone value ????????
mysql的url:jdbc:mysql://127.0.0.1:3306/xingblog_db?serverTimezone=UTC缺少时区原创 2020-06-20 18:01:02 · 143 阅读 · 0 评论 -
Exception in thread "main" java.sql.SQLException: The server time zone value '�й���ʱ��' is unrecogn
问题:Exception in thread "main" java.sql.SQLException: The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (...原创 2020-04-07 17:49:51 · 3176 阅读 · 1 评论