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