I am getting an error in mysql update query using inner join

Question

I have got an error in running this query in phpMyadmin. The query is to update a table using inner join .Pls help me

My tables are :

userpswd

oncampus

I already have gone through most of the threads given here regarding the same and none seem to work.

UPDATE userpswd
SET oncampus_present='yes'
FROM userpswd
INNER JOIN oncampus
ON userpswd.ID=oncampus.ID
WHERE userpswd.oncampus_present=NULL

#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 'FROM userpswd INNER JOIN oncampus ON userpswd.ID=oncam' at line 3 — Param Bhatt, Jun 03 '19 at 13:31
That error message SHOULD have been posted in your question before pressing the Ask button — RiggsFolly, Jun 03 '19 at 13:43

score 0 · Accepted Answer · answered Jun 03 '19 at 13:33

0

You have an error in your SQL syntax

Try This

UPDATE userpswd
INNER JOIN oncampus
ON userpswd.ID=oncampus.ID
SET oncampus_present='yes'
WHERE userpswd.oncampus_present IS NULL

answered Jun 03 '19 at 13:33

Ali Ghaini

1 Answers1