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 '("123456")where user="root"'
时间: 2023-07-09 13:31:04 浏览: 112
This error indicates that there is a syntax error in the SQL statement you are trying to execute, specifically near the word "where". It seems like you are trying to update a record in a MySQL database but have not constructed the SQL statement correctly.
Without seeing the full SQL statement, it is hard to pinpoint the exact issue, but one possible reason for this error could be that you are not enclosing the value "123456" in quotes. In SQL, string values must be enclosed in single or double quotes.
Here is an example of how to correctly update a record in MySQL:
```
UPDATE table_name SET column_name = 'new_value' WHERE some_column = 'some_value';
```
Make sure you are following the correct syntax and that all values are properly quoted.
阅读全文