MYSQL
关注
分享
扫一扫
文章平均质量分 80
corpse2010
这个作者很懒，什么都没留下…
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
容器mysql安装访问
[root@corpse network-scripts]# docker pull hub.c.163.com/library/mysql [root@corpse network-scripts]# docker images REPOSITORY TAG IMAGE ID CREATED SIZE tomcat ...原创 2021-01-02 16:37:57 · 175 阅读 · 0 评论 -
You have an error in your SQL syntax;
报错： You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank WHERE rank.row_num < 11 )' at line 52 ...原创 2020-04-22 13:29:54 · 293 阅读 · 0 评论 -
Data truncation: Division by 0
2020-04-22 12:31:04 [ERROR] [ XXXTF(0-1)] (c.b.w.k.t.ApplicationCallRelationshipTask:124) Error occurred when executing Appliation-Call-Relationship analysis task. Exception : java.sql.BatchUpdateExce...原创 2020-04-22 12:32:59 · 3051 阅读 · 1 评论 -
Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot get a connection, p
报文： ### The error occurred while executing a query ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cann...原创 2020-04-22 11:25:45 · 2689 阅读 · 0 评论 -
Navicat Premium连接oracle数据库报错：ORA-12705: Cannot access NLS data files or invalid environment spe
Navicat Premium 软件连接oracle数据库报错：30ORA-12705: Cannot access NLS data files or invalid environment specified ========================== 配置 NLS_LANG SIMPLIFIED CHINESE_CHINA.ZHS16GBK 登录上去了！...原创 2020-03-24 20:20:46 · 1731 阅读 · 0 评论 -
MySQL 字符串转换为日期
MySQL Str to Date （字符串转换为日期）函数：str_to_date(str, format)select str_to_date('08/09/2008', '%m/%d/%Y'); -- 2008-08-09select str_to_date('08/09/08' , '%m/%d/%y'); -- 2008-08-09select str_to_date('08.09.20...原创 2018-05-16 17:19:48 · 609 阅读 · 0 评论