Yes. Assuming you are comfortable using the mysql client program you could use:
CREATE TABLE newtablename SELECT * FROM existingtablename; In addition, if you have an existing table and need to load data from a text file you could use: LOAD DATA INFILE 'textfilename.txt' INTO TABLE existingtablename; There are many variations on these themes, but this should get you pointed in the right direction. Hope it helps. Craig Ostrander At 06:38 AM 4/15/2002, you wrote: >Hi > >Is it possible to create a new table from the results of a query, or export >the result directly to a file (txt, csv, excel or alike) using MySQL? How is >it done? > >Thanks > >Renger > > >_________________________________________________ > >ECOPLAN >Forschung und Beratung in Wirtschaft und Politik >Economic Research and Policy Consultancy >Thunstrasse 22 / CH-3005 Berne (Switzerland) >Phone: +41 31 356 61 61 / Fax: +41 31 356 61 60 >mailto:[EMAIL PROTECTED] / http://www.ecoplan.ch> > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ======================================================= Craig Ostrander Blue Forest Software and Development Inc Database Design Consultants Worldwide MySQL // SAP DB // Oracle // Microsoft SQL Server // Microsoft Access Need help now? [EMAIL PROTECTED] or +1 530 326 5680 ======================================================= spam filter: sql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
