![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
exiaozhong
这个作者很懒,什么都没留下…
展开
-
连接Mysql时出现建立SSL连接 警告
Java连接数据库时可以照常运行,但是会出现以下警告:Fri May 22 18:07:03 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 connection must be established by default原创 2020-05-25 15:10:42 · 1424 阅读 · 2 评论 -
mysql时间与字符串之间相互转换
1.时间转字符串DATE_FORMAT(日期,格式字符串)SELECT DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s');2.字符串转时间STR_TO_DATE(字符串,日志格式)SELECT STR_TO_DATE('2019-01-20 16:01:45', '%Y-%m-%d %H:%i:%s');3.时间转时间戳selectunix_timestamp(now());4.字符串转时间戳selectunix_timestamp('2..原创 2020-05-25 14:18:03 · 169 阅读 · 0 评论