How can i correct the syntax of update query with join in mysql? [duplicate]

Question

int i=st.executeUpdate("update tbl_loginprogrammer1
               JOIN tbl_loginprogrammer
               ON tbl_loginprogrammer1.pid = tbl_loginprogrammer.proid
        SET    tbl_loginprogrammer1.assigned = 'project3'
        where pid=(select min(proid) from tbl_loginprogrammer where planguage='java' and status='finished')");

It is showing an error String literal is not properly closed by a double-quote.

How can i overcome this? Thanks in advance.

A string literal can't span multiple lines in Java.

JB Nizet
– JB Nizet

2017-09-20 18:42:16 +00:00
Commented Sep 20, 2017 at 18:42 — JB Nizet
– JB Nizet, Commented Sep 20, 2017 at 18:42

Jacques Amar · Accepted Answer · 2017-09-20 18:48:15Z

0

int i=st.executeUpdate(
"update tbl_loginprogrammer1"+
"  JOIN tbl_loginprogrammer"+
"    ON tbl_loginprogrammer1.pid = tbl_loginprogrammer.proid"+
"  SET    tbl_loginprogrammer1.assigned = 'project3'"+
"  where pid=("+
"     select min(proid) "+
"    from tbl_loginprogrammer "+
"    where planguage='java' and status='finished'"+
"    )");

answered Sep 20, 2017 at 18:48

Jacques Amar

1,8231 gold badge12 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

How can i correct the syntax of update query with join in mysql? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related