You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 1131 where mainid=11 at line 1
This error is caused by using an incorrect syntax for updating a MySQL database. The error message suggests that the problem is with the time value included in the statement.
To resolve this error, you need to check the syntax of your SQL statement and make sure that the time value is formatted correctly. It should be enclosed in quotes and in the format 'HH:MM:SS'. For example:
UPDATE table_name SET time_column = '11:31:00' WHERE mainid = 11;
This statement will update the 'time_column' in 'table_name' to '11:31:00' where the 'mainid' is 11. Make sure to adjust the table name and column name to match your database schema.
原文地址: https://www.cveoy.top/t/topic/b1qL 著作权归作者所有。请勿转载和采集!