Update query in SQL, syntax error while running on java

Question

I'm trying to call the query:

UPDATE questions 
SET 1 = 4
WHERE questionid = 4;

But I keep receiving an SQL syntax error. I have a column in my table called '1', and I want to set that columns value to the integer 4. I tried some other queries(below), but I still the same error.

UPDATE questions 
SET '1' = 4
WHERE questionid = 4;

UPDATE questions 
SET '1' = 4
WHERE 'questionid' = 4;

UPDATE questions 
SET "1" = 4
WHERE questionid = 4;

UPDATE questions 
SET "1" = 4
WHERE "questionid" = 4;

I'm trying to perform this query in java using the executeUpdate() method from the Statement java API.

I know some of you would advise me using a PerformedStatement rather than a regular Statement for building queries, and I will do, once I can figure out why my query isn't accepting that 1 is a column name and not an integer.

Try square brackets around the column name, i.e. SET [1] = 4. On a side note, why would you ever name your column that?! — dub stylee
– dub stylee, Commented Mar 27, 2015 at 19:32

Jens · Accepted Answer · 2015-03-27 20:22:38Z

2

Use backticks arround the column name:

UPDATE questions 
SET `1` = 4
WHERE questionid = 4;

Think about renaming your column.

edited Mar 27, 2015 at 20:22

answered Mar 27, 2015 at 19:14

Jens

69.6k15 gold badges107 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Andrew Brick Over a year ago

ah I knew it was something really basic, thanks alot :D

AAzami · Accepted Answer · 2015-03-27 19:17:45Z

1

Try the following:

UPDATE questions
SET [1] = 2 -- int
WHERE QuestionID = 1;

answered Mar 27, 2015 at 19:17

AAzami

4063 silver badges4 bronze badges

Collectives™ on Stack Overflow

Update query in SQL, syntax error while running on java

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related