Why do I get syntax error when I update from MYSQL?

Question

In order to receive the parameters and update the data, I put the fake data in and run the update.

        UPDATE
        TB_PUSH_MESSAGE
        SET 1=1
        <if test="status != ''">
        , status = #{status}
        </if>
        <if test="body != null">
        , body = #{body}
        </if>
        WHERE
        seq_no = #{seq_no}

but it's get error

Caused by: java.sql.SQLSyntaxErrorException: 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 '1=1 , status = '0'
          WHERE       seq_no = '1'' at line 3

How do I solve this problem if I can't put fake data in it?

SET 1=1, here you are trying to update 1. what is 1 here(Left hand side) ? it is variable ? — Ravindra Kumar, Jul 12 '19 at 10:03
@Ravindra The '1=1' data is fake data for putting in commas. — helpmesolution, Jul 12 '19 at 10:10
At least related to https://stackoverflow.com/questions/37665646/update-equivalent-of-where-1-1. — Dmitriy Popov, Jul 12 '19 at 10:36

Dmitriy Popov · Accepted Answer · 2019-07-12T10:37:45.757

0

The problem seems to be your 1 = 1 statement. In this case, first 1 is treated as "column number one in the table TB_PUSH_MESSAGE". So you can read this line as set seq_no = 1, which is most probably incompatible with type of the column.

update equivalent of WHERE '1' = '1' — this question seems to be helpful/related/duplicate.

edited Jul 12 '19 at 10:37

answered Jul 12 '19 at 10:14

Dmitriy Popov

2,150
3
25
34

Then, how can you complete this sentence without adding fake data? – helpmesolution Jul 12 '19 at 10:15
Maybe `set seq_no = seq_no` if you want this first "without comma" statement? :) – Dmitriy Popov Jul 12 '19 at 10:26

Why do I get syntax error when I update from MYSQL?

1 Answers1