By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,994 Members | 2,073 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,994 IT Pros & Developers. It's quick & easy.

Replace data in mysql with the same primary key

P: 15
Good day, I dont know how to start asking even my title in this question is a kind of confusing. Lets start with this

I have a table called member and reso with the same column called ID and resuNo

all i want is to replace all resuNo in table member using the resuNo in table reso without affecting other datas.


member ---------------- reso
ID = 1 ---------------- ID=1
resuNo= 01 ------------ resuNo=02

so it should look like this

member ---------------- reso
ID = 1 ---------------- ID=1
resuNo= 02 ------------ resuNo=02

I hope you understand :) thanks
Nov 19 '14 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,349
Make an update query where you join the 2 tables on ID.
Nov 19 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.