Pittrap’s Weblog

Random stuff

Posts Tagged ‘MySQL’

MySQL copy one or more fields from one table into another table

Posted by Tim on March 20, 2008

If you’re trying to copy the data from some fields in one MySQL table into a different table you’d do it like so:

INSERT INTO TableOne (Username, Password, Email) (SELECT usern, passw, emailaddress FROM TableTwo)

Posted in Coding, MySQL | Tagged: , | Leave a Comment »