I am developing a new shopping cart using the cubecart system, the client has about 2500 parts in the database. After importing these products into the database I noticed that a good 500 were mis categorized and about 100 were out of date and had...
Recently I needed to update a bunch of rows in mysql with information from another table. I will explain how to do this simple process.
Open up phpmyadmin or similar database editor
view the sql query below
UPDATE updatefrom p, updateto pp
SET pp.last_name = p.last_name