weixin_43852529的博客

1. Check the character_set of MariaDB.mysql[none]> show variables like '%character_set_%';2.Set permanent charset.$ vi /etc/my.cnf.d/client.cnf[client] default-character-se=utf8$ vi /etc/...

Some days ago, my leader tell me to complete a mission that automatically creating a table when starting the SpringBoot project. After struggling for some time, I find some ways that can achieve that...

This problem is not about MySQL database, but about JDBC:Solution:JDBCurl: add parameter zeroDateTimeBehavior=convertToNullJDBCurl: add parameter zeroDateTimeBehavior=round

It can hold values starting at ‘1970-01-01 00:00:01’ (UTC) to ‘2038-01-19 05:14:07’ (UTC).