$sql="UPDATE 'student' SET 'course'='javascript','grade'=88,'WHERE 'id'=3"; prompt after running; connection successful, update failed. 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 ''student' SET 'name'='Xiaoming', 'course'='javascript','grade'=88, 'create_tim' at line 1
Ok, thank you
If you make a typo, the corresponding SQL will be prompted.
I don't understand what you are typing. You can modify it yourself in the web database online management, and then you will be prompted with the sql statement you believe.
Field and table names should use backticks instead of single quotes...the backticks are under the ESC key