Filling up positions?

Question

UPDATE job_details 
    WHERE assigned AS +1 
    WHEN assigned is NULL 
    WHEN student_details.jobscope = job_details.jobscop 
    AND student_details.jobscope1 ='IT'

Is this query right? My motive is to get the assigned row in the database to (+1) each time a student is assigned to a job with a jobscope of IT.

Not in proper format. `SET` is the first thing that is missing — Hanky Panky, Jan 16 '14 at 14:18
Try running the query on the database but rolling back the changes in order to prevent any issues. You can use SQL transactions for that. http://stackoverflow.com/questions/20051957/testing-mysql-query — Chris Bier, Jan 16 '14 at 14:20

score 0 · Accepted Answer · answered Jan 16 '14 at 14:21

0

Try

UPDATE job_details 
JOIN student_details ON student_details.jobscope = job_details.jobscop
SET assigned = (assigned+1) 
WHERE  student_details.jobscope1 ='IT'

answered Jan 16 '14 at 14:21

Nouphal.M

6,304
1
17
28

Also is there a field name with `jobscope1` or is it a mis-spelling – Nouphal.M Jan 16 '14 at 14:23
There is . thank you i have managed to solved it after using the SET function. Thank you! – Angelica Jan 16 '14 at 14:44

Filling up positions?

1 Answers1