<div>
double slash? Interesting...
</div>


<div>
It works, thanks, but now my user has denied access. That's another issue.<br />
I appreciate your help.
</div>


It works, thanks, but now my user has denied access. That's another issue.
I appreciate your help.

<div>
<div class="content wysiwyg-content">
I need to create export a csv file that should be named with date i.e. file20160811.csv<br />
<br />
I have my query.<br />
I tried this:<br />
SET @sql_text = CONCAT(&quot;Select * from Table1 into outfile 'C:\desktop\&quot;,date_format(<wbr />NOW(),'%Y%<wbr />m%d'),&quot;.cs<wbr />v'&quot;);<br />
PREPARE statement FROM @sql_text;<br />
EXECUTE statement;<br />
<br />
I got &nbsp;error Code 1064, error SQL syntax...<br />
<br />
can someone help me to fix this?<br />
<br />
Thanks in advance.
</div>
</div>


I need to create export a csv file that should be named with date i.e. file20160811.csv

I have my query.
I tried this:
SET @sql_text = CONCAT("Select * from Table1 into outfile 'C:\desktop\",date_format(NOW(),'%Y%m%d'),".csv'");
PREPARE statement FROM @sql_text;
EXECUTE statement;

I got  error Code 1064, error SQL syntax...

can someone help me to fix this?

Thanks in advance.

How can I include today's date in filename .csv when using OUTFILE using 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.