Keith Schuster <[EMAIL PROTECTED]> wrote: > Mysql 3.. > > I can't figure this one out > > I need to move data from one mysql table to another > > The hurdle for me is adding additional column values. > > Here is what I have. > > > insert into mytable (column1, column 2, column3) > (Select thiscolumn > From anotherTable), '1', now(); > > It's the 1 and the now() I can't insert. > > Anyone have an idea how to do this? >
INSERT INTO mytable(column1, column2, column3) SELECT thiscolumn, '1', NOW() FROM anothertable -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]