ÃֽŠ°Ô½Ã±Û(DB)
2022.03.01 / 01:26

[MySQL] SELECT¹® ÅؽºÆ®ÆÄÀÏ ÀúÀå (TXT, CSV)

MyData
Ãßõ ¼ö 125


SELECT * FROM [Table_Name] INTO OUTFILE '[File_Path] / [File_Name.txt]' 
FIELDS TERMINATED BY ', ' LINES TERMINATED BY ';

Table_Name = Å×À̺í À̸§

File_Path = ÆÄÀÏÀÌ ÀúÀå µÉ °æ·Î ( ' / ' ·Î ºÐ·ù )

File_Name = ÀúÀåµÉ ÆÄÀÏ À̸§ (txtÆÄÀÏ, csvÆÄÀÏ °¡´É)

FIELDS TERMINATED BY ', ' = ÇÊµå °£ ÅäÅ«°ª ¼³Á¤

LINES TERMINATED BY '\'; = ¶óÀÎ °£ ÅäÅ«°ª ¼³Á¤