jjzjj

fullOutputPath

全部标签

mysql - 我可以使用变量在mysql中指定OUTFILE吗

有没有办法做类似下面的事情?这不起作用,但显示了我想做的事情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

mysql - 我可以使用变量在mysql中指定OUTFILE吗

有没有办法做类似下面的事情?这不起作用,但显示了我想做的事情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