mysql-workbench - 如何将 DISTINCT 数据导出到 DISTINCT 文件

Question

SELECT * 
FROM  `amc_info` 
WHERE department =' ( 
SELECT DISTINCT department ) 
into outfile = 'Different department'

我在 amc_info 中有大量数据，涉及不同的部门。一个部门可能有多于一行，总部门超过30个，现在我想用部门文件名导出此数据。

Answer 1

我认为这就是您想要实现的目标:

SELECT * INTO OUTFILE 'file.txt' 
FROM `amc_info` WHERE department IN (SELECT DISTINCT department FROM `amc_info`)

也查看 SELECT INTO 语法:https://dev.mysql.com/doc/refman/5.1/en/select-into.html

如果您只是想获取不同的部门:

SELECT DISTINCT department INTO OUTFILE 'file_name.txt'
FROM `amc_info`