[plug] mysql query questoin

Jon Miller jlmiller at mmtnetworks.com.au
Mon Jan 20 08:48:04 WST 2003


Thanks to all that submitted their input it is working just fine.

Jon

Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks Pty Ltd
http://www.mmtnetworks.com.au

"I don't know the key to success, but the key to failure
 is trying to please everybody." -Bill Cosby



>>> onno at itmaze.com.au 9:33:20 PM 19/01/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