mysql error in your SQL syntax

Question

I try to write a code to find the nearest value But my code have some syntex error please help
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 '' at line 7

  update member t1
    set Latid = (
        select id 
        from markersphuket t2
        where t2.MU = t1.Moo
        order by abs(t2.hno2 - t1.Hno2)
        limit 1

Do you want to close this parenthesis? set Latid = (

Cheery
– Cheery

2012-01-30 06:31:50 +00:00
Commented Jan 30, 2012 at 6:31 — Cheery
– Cheery, Commented Jan 30, 2012 at 6:31

Sudhir Bastakoti · Accepted Answer · 2012-01-30 06:33:28Z

2

TRy:


update member t1
    set Latid = (
        select id 
        from markersphuket t2
        where t2.MU = t1.Moo
        order by abs(t2.hno2 - t1.Hno2)
        limit 1 )
WHERE 1 // will update all the rows of member table

answered Jan 30, 2012 at 6:33

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

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

Comments

Joshua Kissoon · Accepted Answer · 2012-01-30 06:31:54Z

0

Try:

update member t1
set Latid = (
    select id 
    from markersphuket t2
    where t2.MU = t1.Moo
    order by abs(t2.hno2 - t1.Hno2)
)
    limit 1

answered Jan 30, 2012 at 6:31

Joshua Kissoon

3,3296 gold badges34 silver badges60 bronze badges

Comments

xdazz · Accepted Answer · 2012-01-30 06:32:36Z

0

Did you miss the last )?

  update member t1
    set Latid = (
        select id 
        from markersphuket t2
        where t2.MU = t1.Moo
        order by abs(t2.hno2 - t1.Hno2)
        limit 1
    )

answered Jan 30, 2012 at 6:32

xdazz

161k38 gold badges255 silver badges278 bronze badges

Collectives™ on Stack Overflow

mysql error in your SQL syntax

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related