[plug] mysql query questoin

Onno Benschop onno at itmaze.com.au
Sun Jan 19 21:33:20 WST 2003


On Sun, 2003-01-19 at 21:09, Anne Busby wrote:
> Try
> 
> INSERT INTO <table2> SELECT <fields> FROM <table>;

And if you don't have field names that don't match-up, then you need to
make it so:

INSERT INTO table (field1, field2, field3) SELECT peter AS field1, paul
AS field2, mary AS field3 FROM table2 WHERE something='fred'

-- 
()/)/)()        ..ASCII for Onno.. 
|>>?            ..EBCDIC for Onno.. 
--- -. -. ---   ..Morse for Onno.. 

ITmaze   -   ABN: 56 178 057 063   -  ph: 04 1219 8888   -  
onno at itmaze.com.au



More information about the plug mailing list