mysql
mysql
spencer_tseng
这个作者很懒,什么都没留下…
展开
-
ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘ (10061)
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061)原创 2024-09-11 22:41:08 · 545 阅读 · 0 评论 -
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempt
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.原创 2024-05-28 11:06:22 · 211 阅读 · 0 评论 -
com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value ‘�й���ʱ��‘
com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) t原创 2024-03-21 00:48:04 · 284 阅读 · 0 评论 -
1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key原创 2023-12-15 19:39:08 · 383 阅读 · 0 评论 -
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
1064 - 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 '+ dept_id BIGINT(19) COMMENT '部门ID organization.id', dept_code VARC' at line 10原创 2023-12-15 19:15:37 · 368 阅读 · 0 评论 -
Failed to open the referenced table ‘qrtz_job_details‘
Failed to open the referenced table 'qrtz_job_details'原创 2023-12-14 13:53:05 · 451 阅读 · 0 评论 -
mysql CREATE DATABASE
mysql CREATE DATABASE原创 2023-12-14 13:17:54 · 410 阅读 · 0 评论 -
<mysql-connector-java.version>
5.1.47com.mysql.jdbc.Driver8.0.16com.mysql.cj.jdbc.Driver原创 2023-11-18 20:58:51 · 296 阅读 · 0 评论 -
Establishing SSL connection without server‘s identity verification is not recommended. According to
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 if explicit option isn't set. For compliance with existing appl原创 2023-11-18 20:47:39 · 93 阅读 · 0 评论 -
com.mysql.cj.exceptions.CJException: Access denied for user ‘root‘@‘localhost‘ (using password: YES)
Caused by: com.mysql.cj.exceptions.CJException: Access denied for user 'root'@'localhost' (using password: YES)原创 2023-10-23 00:17:19 · 586 阅读 · 0 评论 -
Loading class `com.mysql.jdbc.Driver‘. This is deprecated.
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.原创 2023-10-23 00:08:52 · 259 阅读 · 0 评论 -
mysql varchar & int
印象中oracle好像也是吧。年龄是字符类型varchar。年龄是数字类型int。原创 2023-10-19 11:27:26 · 171 阅读 · 0 评论 -
ERROR 1064 - You have an error in your SQL syntax;
ERROR 1064 - 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 '('/',原创 2023-07-28 20:05:21 · 574 阅读 · 0 评论 -
select @@basedir;
select @@basedir;原创 2023-04-06 20:13:56 · 361 阅读 · 0 评论 -
[Err] 1055 - Expression #1 ...... this is incompatible with sql_mode=only_full_group_by
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column '' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by原创 2023-04-06 20:00:16 · 119 阅读 · 0 评论 -
mysql information_schema
mysql information_schema原创 2023-04-05 15:05:23 · 72 阅读 · 0 评论 -
java.sql.SQLSyntaxErrorException: FUNCTION psp.nvl does not exist
java.sql.SQLSyntaxErrorException: FUNCTION psp.nvl does not exist原创 2023-03-12 22:13:40 · 96 阅读 · 0 评论 -
Could not create connection to database server. Attempted reconnect 3 times. Giving up.
java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.原创 2023-02-21 18:56:54 · 655 阅读 · 0 评论 -
The reference to entity “useSSL“ must end with the ‘;‘ delimiter.
The reference to entity "useSSL" must end with the ';' delimiter.原创 2022-12-08 16:57:49 · 289 阅读 · 1 评论 -
java.sql.SQLException: Access denied for user ‘crm‘@‘localhost‘ (using password: YES)
java.sql.SQLException: Access denied for user 'crm'@'localhost' (using password: YES)原创 2022-11-29 11:21:30 · 358 阅读 · 0 评论 -
java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed] with root cause
java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed] with root cause原创 2022-11-29 03:22:29 · 1143 阅读 · 0 评论 -
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
1064 - 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 'INSERT INTO `tbl_dic_type` VALUES原创 2022-11-29 03:02:01 · 457 阅读 · 0 评论 -
mysql utf8mb4 utf8mb4_general_ci
mysql utf8mb4 utf8mb4_general_ci原创 2022-11-20 01:22:13 · 394 阅读 · 0 评论 -
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full原创 2022-11-16 22:50:23 · 228 阅读 · 0 评论 -
Unknown initial character set index ‘255‘ received from server
Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.原创 2022-10-20 23:35:51 · 235 阅读 · 0 评论 -
mysql show plugins;
mysql show plugins;原创 2022-10-20 19:27:03 · 286 阅读 · 0 评论 -
mysql explain
mysql explain原创 2022-10-17 11:20:43 · 248 阅读 · 0 评论 -
MySQL AUTOCOMMIT
MySQL AUTOCOMMIT原创 2022-10-15 18:26:04 · 121 阅读 · 0 评论 -
1130 - Host ‘0.0.0.0‘ is not allowed to connect to this MySql server
1130 - Host '0.0.0.0' is not allowed to connect to this MySql server原创 2022-10-08 01:23:00 · 211 阅读 · 0 评论 -
mysql-8.0.30-winx64
mysql-8.0.30-winx64原创 2022-10-08 01:06:33 · 822 阅读 · 0 评论 -
mysqld.service failed because the control process exited with error code
mysqld.service failed because the control process exited with error code原创 2022-09-04 21:55:59 · 998 阅读 · 0 评论 -
mysql client: character_set_results
mysql client: character_set_results原创 2022-09-04 01:12:13 · 287 阅读 · 0 评论 -
java.sql.BatchUpdateException: Incorrect string value: ‘\xE6\x96...‘ for column ‘title‘ at row 1
java.sql.BatchUpdateException: Incorrect string value: '\xE6\x96...' for column 'title' at row 1原创 2022-09-04 00:52:51 · 709 阅读 · 0 评论 -
Host ‘0.0.0.0‘ is not allowed to connect to this MySQL server
Host '0.0.0.0' is not allowed to connect to this MySQL server原创 2022-09-04 00:50:45 · 127 阅读 · 0 评论 -
mysql ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)原创 2022-09-04 00:23:07 · 323 阅读 · 0 评论 -
MySQL 5.5
MySQL 低版本问题原创 2022-07-11 09:17:44 · 310 阅读 · 0 评论 -
mysql java.sql.SQLException: Unknown initial character set index ‘255‘ received from server
java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.Class.forName("com.mysql.jdbc.Driver");private static String url = "jdbc:mysq...原创 2021-01-11 09:56:50 · 804 阅读 · 2 评论 -
mysql culumn chartset
MySQL 字符集问题:(后面再完善下demo赶时间)原创 2021-01-06 16:11:58 · 117 阅读 · 0 评论 -
MySQL Join Types
阳光照耀着大家,嘿嘿,周末愉快!原创 2022-01-07 21:03:35 · 407 阅读 · 0 评论 -
mysql enum
package enum_test;public enum DataType{ oracle, kafka; public static DataType getItem(String strItem) { for (DataType item: values()) { if (item.toString().equals(strItem)) ...原创 2020-04-26 23:42:02 · 175 阅读 · 0 评论