mysql sql_ mode=only_ full_ group_ The problem is solved temporarily
Boring ape 2022-02-13 07:44:15 阅读数:942
mysql
sql_
sql
mode
only_
Execute code
set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
Only temporarily valid , restart sql after , Or it doesn't work
Tried to modify the configuration file
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
useless ！ my sql Version is 8.0.20
Big guys with solutions , Welcome to leave a message ！
copyright：author[Boring ape]，Please bring the original link to reprint, thank you. https://en.javamana.com/2022/02/202202130744139456.html
- Java compilation error: compilation failed
- Spring cloud startup error
- Java AWT stack overflow
- Zipfile invalid LOC header error in spring boot project
- Unexpected EOF read on the socket
- Spring security filterinvocation failed to get access path
- Springboot error
- Java program and vsftpd failed to upload files on the same machine. The file size is 0
- How to solve the error of PM2 installed offline under Linux
- There are too many zombie processes under the Linux top command. How do you know which process caused it
- Spring @ Autowired implementation details you don't know
- Mybatis plug-in extension and integration principle with spring
- Go deep into mybatis source code - execution process
- This time, understand the core principles of springboot (automatic configuration, event driven, condition)
- Understand the principle of spring MVC this time
- This time, understand the bean instantiation principle of spring
- This time, understand the XML parsing principle of spring
- In depth mybatis source code - configuration analysis
- On the source code of mybatis -- elegant and excellent skeleton
- Mysql database 5 --- database lock
- Mysql database 4 --- database index
- Mysql database 3 --- database storage engine
- Mysql database 2 - complex SQL commands
- Mysql database 1 - basic database commands
- HashMap and hashtable of the set
- Springboot interview questions
- Redis interview questions
- Design mode
- Mybatis interview questions
- Spring interview questions
- Redis tool class
- Mybatis plus (use of crud)
- Springboot integrates springsecurity II
- Dynamic SQL statements in mybatis framework
- Mybatis one to many query
- Mybatis executes many to one queries
- Three methods for spring MVC to obtain parameters -- Idea
- Addition, deletion and modification of mybatis - idea
- Introduction to mybatis - idea
- Spring MVC framework construction - idea
- Use Tomcat server, database, JSP and HTML to realize user registration
- Mysql database operation using JDBC
- Java school last semester's question, who can give a reference answer
- The data structure course is designed with queues to achieve the following
- MySQL Chinese garbled code has been changed to utf8. Is that still the case
- Help me see if the Hadoop cluster is successfully built and running, right
- What's the difference between flightboot and springboot
- How to learn Java? Recommended books? Please let me know!
- An error is reported when a website requests HTTPS using the requests module in Python
- What if Vue fails to access static resources after being deployed to a Linux server?
- If dynamic continuous results are needed, top Linux processes have five states. What are the corresponding status codes?
- How to deal with the unexpected result of logging in to Oracle
- When deploying the Vue project on the nginx server on Linux, you can only access the home page and other pages 404
- RM - RF / what if you really delete all Linux hard disk files!
- Library management system website (Application Technology: bootstrap, jQuery, JavaScript)
- Using jQuery to make simple addition and deletion of employee information
- Using JavaScript to do a simple page Jump
- MySQL basics -- 004 other database objects: views, stored procedures and functions, variables, process control and cursors, triggers
- MySQL basics -- 003 SQL DDL, DML and DCL usage: creating and managing tables, adding, deleting and modifying data processing, MySQL data types, constraints
- MySQL basics -- select usage of 002 SQL: basic select statements, operators, sorting and paging, multi table query, single line function, aggregate function, sub query