select * into outfile '2011-05-18.txt' from a;
select * into outfile '2011-05-19.txt' from a;
select * into outfile '2011-05-20.txt' from a;
如何做呢?
...全文
896打赏收藏
如何使用动态可变的SQL语句?
我想每天都把一个表的数据保存到文件中 select * into outfile ... from a; 但是这个文件名我想就是今天的日期。 select * into outfile '2011-05-18.txt' from a; select * into outfile '2011-05-19.txt' from a; select * into outfile '2011-05-20.txt' from a; 如何做呢?