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?
SELECT bizID,bizName,bizAddr,bizCity,bizState,bizZip,bizPhone,bizLive FROM biz_cars GROUP BY bizPhone ORDER BY bizName INTO OUTFILE '/home/carsout.txt'