有没有办法做类似下面的事情?这不起作用,但显示了我想做的事情SET@OutputPath='/Users/jo/Documents'SET@fullOutputPath=CONCAT(@OutputPath,'/','filename.csv')SET@fullOutputPath2=CONCAT(@OutputPath,'/','filename2.csv')SELECT*INTOOUTFILE@fullOutputPathFIELDSTERMINATEDBY','OPTIONALLYENCLOSEDBY'"'FROMdatabase.tableName;SELECT*INTOOUT
有没有办法做类似下面的事情?这不起作用,但显示了我想做的事情SET@OutputPath='/Users/jo/Documents'SET@fullOutputPath=CONCAT(@OutputPath,'/','filename.csv')SET@fullOutputPath2=CONCAT(@OutputPath,'/','filename2.csv')SELECT*INTOOUTFILE@fullOutputPathFIELDSTERMINATEDBY','OPTIONALLYENCLOSEDBY'"'FROMdatabase.tableName;SELECT*INTOOUT