MySQL Error in the FROM statement: FROM is not a valid input at this position

Question

In this error it indicates that the

"FROM is not a valid input at this position".

Here is the code which is an insert statement with JOIN clause

UPDATE phpcollab.projects

SET ph.APPROVED='2',
    pd.currentBudget = pd.currentbudget - ph.totalvalue

FROM phpcollab.projects pp JOIN phpcollab.photo ph
                             ON pp.projectID = ph.id
WHERE ID='1';

Mureinik · Accepted Answer · 2016-10-08 23:33:56Z

6

MySQL's update-join syntax doesn't use a from clause:

UPDATE phpcollab.projects pp
JOIN   phpcollab.photo ph ON pp.id = ph.projectID
SET    ph.APPROVED = '2',
       pp.currentBudget = pp.currentbudget - ph.totalvalue
WHERE  ph.id = '1';

edited Oct 8, 2016 at 23:33

answered Oct 8, 2016 at 23:18

Mureinik

316k54 gold badges401 silver badges405 bronze badges

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

2 Comments

Marco M Over a year ago

Is there anyway I could call the data from the other table? Because I want to subtract a data from the photos table to the projects table

Mureinik Over a year ago

@MarcoM. Of course - you can use table aliases and relate to data in the other table(s) like my example shows.

Collectives™ on Stack Overflow

MySQL Error in the FROM statement: FROM is not a valid input at this position

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related