mysql8 datetime 0000:00:00 에러 발생 시

1. 현재 설정된 모드 확인 쿼리 show variables like 'sql_mode' mysql server sql modes 확인 MySQL :: MySQL 8.0 Reference Manual :: 5.1.11 Server SQL Modes The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable. DBAs can set the global SQL mode to match site server operating requirements, and each de..

2021.03.30