Error in editing MySql to change the date, the code is as follows:
mysql> Insert into date values (‘ Zhangsan ‘,92-01-02,99-03-04);
ERROR 1292 (22007): pendate value: ’89’ for column ‘birth’ at row 1
changed to
mysql> Insert into date values (‘zhangsan’,19920102,19990304);
Query OK, 1 row affected (0.13 SEC)
succeeds.
It should be the length of the date input.
mysql> Insert into date values (‘ Zhangsan ‘,92-01-02,99-03-04);
ERROR 1292 (22007): pendate value: ’89’ for column ‘birth’ at row 1
changed to
mysql> Insert into date values (‘zhangsan’,19920102,19990304);
Query OK, 1 row affected (0.13 SEC)
succeeds.
It should be the length of the date input.
Read More:
- Mysql reports an error Operand should contain 1 column(s)
- Mysql database error (communications link failure)
- The problem of MySQL database connection failure errno: 1049 error
- Resolve the exception MySQL lontransientconnectionexception: communications link failure during rollback()
- Nebula queries data and reports an error. Storage error: part: XX error: e_ RPC_ FAILURE(-3).
- Docker starts MySQL container and reports an error driver failed programming external connectivity on endpoint mysq
- Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure (How to Fix)
- Zeppelin uses spark to connect to MySQL and reports an error
- When executing hive – f script com.mysql.jdbc . exceptions.jdbc4 .CommunicationsException: Communications link failure
- QT + MySQL generates an EXE file and reports an error “driver not loaded”. Solution steps
- MySQL reports fatal error encoded during command execution. How to solve the error
- Top35: pychar reports an error when connecting to MySQL server returns invalid timezone. Need to set ‘servertimezone’ property
- To be solved: one SSD failure, format failure
- Solutions for failure to start Axure RP (including failure to uninstall or install. Net framework)
- MySQL error set: failed to start mysql.service : Unit mysql.service is masked.
- (error when importing database): MySQL 2006-mysql server has gone away
- MySQL local connection Error 1130_ The solution of MySQL 1130 error report when remote connection through Navicat for MySQL
- Hadoop reports an error. Cannot access scala.serializable and python MapReduce reports an error
- The echots in Vue reports an error. After obtaining the DOM element, the chart can be displayed. The console still reports an error
- HTML method IE8 reports an error, IE8 jQuery Ajax obtains static resources reports an error, typeerror denies access