sql transaction error

Question

I am very new to SQL. I am at a loss as to what my problem is. Any help would be greatly appreciated.

START TRANSACTION;
UPDATE hsitems SET price = price *2 WHERE partID = AX12;
COMMIT;

1054 - Unknown column 'AX12' in 'where clause'

Seems pretty clear to me that there's no column named `AX12`. If it's a value to compare against, it should be enclosed in single quotes as in `'AX12'` — The Impaler, Apr 13 '18 at 20:32

score 0 · Answer 1 · answered Apr 13 '18 at 20:08

0

Try

UPDATE hsitems SET price = price *2 WHERE partID = "AX12";

That is assuming the partID is a varchar or char column.

answered Apr 13 '18 at 20:08

luksch

Question should be closed because it's a typo. – Liora Haydont Apr 13 '18 at 20:09