you want to do insert into mytable (column1, column2, column3) (select thiscolumn, '1', now() from anotherTable);
> 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? > > > > > ------------------------------- > Keith Schuster > Schuster & Company LLC > ph:704-799-2438 > fx:704-799-0779 > iChat/AIM:FSHSales > > WWW.FlagShipHosting.com > WWW.Schusterandcompany.com > WWW.Vsheet.net > -------------------------------- > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
