very simple help with a sql query
I want to update the passwords in table 1, with the passwords in table 2
Where table 1 ID = Table2 ID
for example the below did not work.
table1 = goth_users
table2 = goth_users___
SET [url removed, login to view] = [url removed, login to view]
FROM goth_users___ PASSWORD
WHERE [url removed, login to view] = [url removed, login to view]
77 freelancers are bidding on average $17 for this job
Hi, We have experience with php and my sql. We did many sites, you can check my account or here: http://www.arrowhitech.com/portfolio/wordpress-projects Let me do it for you Thanks, David
Its very simple. It can be solved by just a join, can give you solution very faster. if your database is huge, can provide you the script for doing in batches if you need
I can work on your project......... give me a chance to approve my self and I'm sure you will satisfied with my work results. We will ensure you that We will produce quality of work.
Hi, try this UPDATE goth_users SET goth_users.PASSWORD = (select goth_users___.PASSWORD FROM goth_users___ WHERE goth_users.ID = goth_users___.ID) Regards, Dmitry