Database: How to import data from another table ?
Migrated from vBulletin4. This is table: gdn_user, column: Photo related.
I would like to import generated data from another table/column into gdn_user's Photo column.
Tried this: pastebin.com/pbvD23AB
But it fills the Photo column after the last user id
So, I have 5000 members, generated 5000 image paths. When filling with above command, it fills from 5001 to 10000.. grr
I would like to fill into existing ids.. from 1 to 5000
I'm sure there are some mysql gurus arouns here
Please, I would really appreciate a hand.
Thank you so much