MYSQL 导出数据脚本,该如何解决

MYSQL 导出数据脚本
执行一条SQL语句导出一段SQL语句查询出来的数据集到 到一个TXT文件中，请问如何实现，谢谢


用的客户端是windows 操作系统 下 Navicat Premium
MYSQL 5.09
------------------------

类似MS SQL exec master..xp_cmdshell 'bcp "select * fromt table_name" queryout c:\dt.ext -c servername -usa -p password'

[解决办法]
select * into outfile "c:\a.txt" from tb where ...
[解决办法]
权限不够，换ROOT
[解决办法]

探讨

引用:
select * into outfile "c:\a.txt" from tb where ...

[Err] 1045 - Access denied for user 'User'@'%' (using password: YES)

[解决办法]
导出select * into outfile '/home/mysql/test.txt' from tbname
导入 load data infile '/home/mysql/text.txt' into table tbname
[解决办法]
检查你的权限，用SELECT INTO OUTFILE
[解决办法]
1、SELECT INTO OUTFILE
2、MYSQLDUMP
mysqldump -uroot -p DBNAME TTNAME> r:\temp\a.sql
3
mysql -uroot -p -e "SELECT * FROM TT">r:\temp\123.txt
[解决办法]
1、SELECT INTO OUTFILE
2、MYSQLDUMP
mysqldump -uroot -p DBNAME TTNAME> r:\temp\a.sql
3
mysql -uroot -p -e "SELECT * FROM TT">r:\temp\123.txt

查看更多 下一篇