MySQL UPDATE problem
Posted
by comma
on Stack Overflow
See other posts from Stack Overflow
or by comma
Published on 2010-04-23T04:30:17Z
Indexed on
2010/04/23
4:33 UTC
Read the original article
Hit count: 337
mysql
I know the following MySQL code is not correct can some help me fix this code to use both tables I'm trying to grab the id
from learned_skills
and skill_id
from users_skills
for AND skill_id = id
Here is the MySQL code.
SELECT learned_skills.*, users_skills.*
UPDATE learned_skills
SET skill = '$skill', experience = '$experience', years = '$years'
WHERE user_id = '$user_id'
AND skill_id = id
© Stack Overflow or respective owner