MYSQL
关注
分享
扫一扫
文章平均质量分 80
corpse2010
这个作者很懒，什么都没留下…
展开
-
容器mysql安装访问
[root@corpse network-scripts]# docker pull hub.c.163.com/library/mysql[root@corpse network-scripts]# docker imagesREPOSITORY TAG IMAGE ID CREATED SIZEtomcat ...原创 2021-01-02 16:37:57 · 145 阅读 · 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 · 244 阅读 · 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 · 2952 阅读 · 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 · 2611 阅读 · 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 · 1585 阅读 · 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 · 565 阅读 · 0 评论