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 existingt
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
Econom
