Simple MySQL Update Query not working - mysql error 1064

Asked Dec 22 '20 at 15:57

Active Dec 26 '20 at 19:24

Viewed 93 times

I have a super simple query.

The query is:

UPDATE tbl_name SET col_name = 'A934451' WHERE col_name ='B034451';

Every time I run it the output is:

mysql error 1064 – you have an error in your sql syntax

In order to try to get it to work I have tried adding the schema to the start of the table, enclosing the column name in backtick's but with no luck. The error appears at the end of the first col_name (before the equals sign).

(Note I have changed the table and column names but syntax is exactly the same - ie two words separated by an underscore).

I would really appreciate it if anyone can take the time to point me in the right direction. Fairly certain this is a case of not seeing the wood for the trees.

edited Dec 26 '20 at 19:24

halfer

19,824
17
99
186

asked Dec 22 '20 at 15:57

John Ortt

This can sometimes happen if you are not using the correct single quotes for the string. – Gordon Linoff Dec 22 '20 at 15:58
what's your table schema? – eshirvana Dec 22 '20 at 16:21
1

Provide COMPLETE error message - do not cut off the tail. Also provide real SQL text and MySQL version. – Akina Dec 22 '20 at 17:55
Try https://stackoverflow.com/questions/23515347/how-can-i-fix-mysql-error-1064 so you possibly find the error yourself and you understand why we need more information. – h.m.i.13 Jan 16 '21 at 13:42

Simple MySQL Update Query not working - mysql error 1064

0 Answers0