SQL syntax error UPDATE / WHERE

Question

So I keep getting SQL syntax error when trying to run the following:

UPDATE tickets SET (ticket_urgency, ticket_status) VALUES ('Urgent', 'new') WHERE ticket_id='14'

Not sure what is wrong with this? I tried INSERT INTO aswell, but the tricky part here is the WHERE tiket_id='x'.

score 4 · Answer 1 · edited May 23 '17 at 10:34

4

the syntax of UPDATEshould be like this,

UPDATE tickets 
SET    ticket_urgency = 'Urgent', 
       ticket_status = 'new'
WHERE  ticket_id='14'

UPDATE

for further knowledge, your query is vulnerable to SQL Injection if the values came from a variable, to protect from it, please read the article below

How can I prevent SQL injection in PHP?

edited May 23 '17 at 10:34

Community

1
1

answered Dec 06 '12 at 05:42

John Woo

258,903
69
498
492

Thanks, this worked. I'll read more about that. (can't upvote :P) – user1868565 Dec 06 '12 at 05:46

score 1 · Answer 2 · answered Dec 06 '12 at 05:43

1

your syntax is not correct please correct it

UPDATE tickets 
SET ticket_urgency = 'Urgent', 
    ticket_status = 'new'
 WHERE ticket_id='14'

answered Dec 06 '12 at 05:43

Murali N

3,451
4
27
38

SQL syntax error UPDATE / WHERE

2 Answers2