The SQL query failed, and the root cause turned out to be the case sensitivity of table names!By editing lower_case_table_names=1 in my.conf, it is set to be case-insensitiveAfter restarting the MySQL server, the SQL statement runs normally. However, it is generally recommended to keep table names consistent with the code’s casing, and ideally use all lowercase!
