Getting Syntax Error for update query in mysql

Question

Error:

> #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use
> near 'where `membership_num`='1'' at line 1

Query:

   UPDATE `MEMBERSHIP` 
    SET `member_id`= 2, 
        `sales_id`=1,
        `duration`='3 شهور',
        `start_date`='2016-10-16',
        `end_date`='2016-10-16',
        `membership_cost_before`=500,
        `discount`=0,
        `member_ship_cost` =500,
        `membership_type` ='Silver',
        `amout_done` =500,
        `amount_reminder` = 0,
        `trainer_id` = 
     WHERE `membership_num`=1

Put any value for trainer_id = ? before where condition

Piyush Gupta
– Piyush Gupta

2016-07-16 05:38:19 +00:00
Commented Jul 16, 2016 at 5:38 — Piyush Gupta
– Piyush Gupta, Commented Jul 16, 2016 at 5:38
Thank You for answer it working (Y)

Ahmed Alaa Eldeen
– Ahmed Alaa Eldeen

2016-07-16 06:17:23 +00:00
Commented Jul 16, 2016 at 6:17 — Ahmed Alaa Eldeen
– Ahmed Alaa Eldeen, Commented Jul 16, 2016 at 6:17

Charlie Fish · Accepted Answer · 2016-07-16 05:35:00Z

1

trainer_id = where membership_num=1

You have to specify what trainer_id is. Right now you just have an = sign with nothing after so that is the syntax error.

answered Jul 16, 2016 at 5:35

Charlie Fish

21k23 gold badges108 silver badges204 bronze badges

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

2 Comments

Charlie Fish Over a year ago

trainer_id=NULL WHERE membership_num=1

Charlie Fish Over a year ago

@AhmedAlaaEldeen No problem! Glad I could help!! :)

Piyush Gupta · Accepted Answer · 2016-07-16 05:51:02Z

1

You forget to put value for trainer_id= so Put any value for trainer_id before where condition, Here I'm putting Null value trainer_id=Null

Try this Query

UPDATE `MEMBERSHIP` 
    SET `member_id`= 2, 
        `sales_id`=1,
        `duration`='3 شهور',
        `start_date`='2016-10-16',
        `end_date`='2016-10-16',
        `membership_cost_before`=500,
        `discount`=0,
        `member_ship_cost` =500,
        `membership_type` ='Silver',
        `amout_done` =500,
        `amount_reminder` = 0,
        `trainer_id` =NULL 
     WHERE `membership_num`=1

Note: Make sure trainer_id column should be set not null false in database structure if you want to update null value for that.

edited Jul 16, 2016 at 5:51

answered Jul 16, 2016 at 5:41

Piyush Gupta

2,1813 gold badges16 silver badges28 bronze badges

Collectives™ on Stack Overflow

Getting Syntax Error for update query in mysql

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related