<div>
Is there an option using the mysql command to set a delimiter and line sperator and enclosing each value by qoutes . Basically to change the format the values are written to the file.<br />

</div>


Is there an option using the mysql command to set a delimiter and line sperator and enclosing each value by qoutes . Basically to change the format the values are written to the file.


<div>
<div class="content wysiwyg-content">
Hi , <br />
<br />
Is there a batch process there for downloading data from mysql db to a file &nbsp;like there is LOAD DATA INFILE for uploading. There is an option where you can redirect the result set from a select query onto a &nbsp;file using OUTFILE. But i am looking for a more faster process.<br />
<br />
Thanks in advance<br />

</div>
</div>


Hi , 

Is there a batch process there for downloading data from mysql db to a file  like there is LOAD DATA INFILE for uploading. There is an option where you can redirect the result set from a select query onto a  file using OUTFILE. But i am looking for a more faster process.

Thanks in advance


OUTFILE option in mysql

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.