Tag: my.ini
-
Post Views: 16 1. Set the default value of DateTime in MySQL 8.0 to be0000-00-00 00:00:00Time error: sqlstate[42000]: Syntax error or access Violation: 1067 Invalid default value forOPERATED_AT_GMT. as shown in Figure 1 2. Reference:https://www.shuijingwanwq.com/2022/09/28/6993/In Navicat for MySQL, when the table is copied from one database to another, an error is reported:[ERR]1292 – Incorrect DateTime Value: ‘0000-00-00 00:00:00’ for column…
-
Post Views: 17 1. In Navicat for MySQL, import the SQL file, and report an error when executing: 2006 – MySQL Server has gone away. as shown in Figure 1 2. The size of the imported SQL file is about 35MB. as shown in Figure 2 3. The reason is that the default settings of max_allowed_packet are very low. In…
-
Post Views: 111 1. Laravel Sail requires Windows 10 systems that support WSL 2. The 2004 version released in May 2020 only supports the WSL 2 function, so our system needs to be updated to the 2004 version equal to or greater than the 2004 version. To view the system version, you can use the winver command, refer to Windows…
-
Post Views: 14 1. Mysql error: 1055 – expression #2 of select list is not in group by clause and contains nonaggregated columnmodel.group_idwhich is not functionally depend on columns in group by cluse; as shown in Figure 1 2. Execute the first SQL clause, no error is reported, and the query result is empty. as shown in Figure 2 3.…