Update child records with parent records mysql

Asked Sep 26 '16 at 09:57

Active Sep 26 '16 at 09:57

Viewed 114 times

I have two tables one called profile and the other pictures. In the picture table there is a field that is supposed to have the parent_id inserted in the field. I used the below script in MSSQL SERVER and it worked but it fails to work on mysql

update pictures 
  set up_user_id = (
               select profile.profile_id 
                 from profile 
                where profile.email = pictures.email
              )

when i execute i get 0 rows affected.

asked Sep 26 '16 at 09:57

user6579134

Are you sure that there _should_ be any row affected? Did you check your data? – Tim Biegeleisen Sep 26 '16 at 09:59
is this for mysql or for sql-server ? – GuidoG Sep 26 '16 at 10:00
This query must be work,check both table properly and also make sure if you are making condition for specific row then use where clause in update statement – Bharat Sep 26 '16 at 10:03
@GuidoG, it worked on mssql server but i'm now using it on mysql and it doesn't work – user6579134 Sep 26 '16 at 10:04
did you try running the sub query independently to see if there are rows? – e4c5 Sep 26 '16 at 10:22

Update child records with parent records mysql

0 Answers0