seopti
asked on
MySQL Select INTO OUTFILE question
I run a query which successfully selcts INTO OUTFILE.
But I would like to keep the mysql structure when this select is done, so the result should not be a text file, but the table,rows ... should also be included into this file, is this possible?
The goal is to import these SELECT results again after this select has been performed, but I just can't import a text file output.
Which command should I use instead of INTO OUTFILE in order to be able to import the results back into my MySQL table?
But I would like to keep the mysql structure when this select is done, so the result should not be a text file, but the table,rows ... should also be included into this file, is this possible?
The goal is to import these SELECT results again after this select has been performed, but I just can't import a text file output.
Which command should I use instead of INTO OUTFILE in order to be able to import the results back into my MySQL table?
SELECT bizID,bizName,bizAddr,bizCity,bizState,bizZip,bizPhone,bizLive FROM biz_cars GROUP BY bizPhone ORDER BY bizName INTO OUTFILE '/home/carsout.txt'
ASKER
I know mysqldump, the question is, how can I dump those results which I have selected into a .sql file?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html