ÃֽŠ°Ô½Ã±Û(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 '\'; = ¶óÀÎ °£ ÅäÅ«°ª ¼³Á¤
'Development Language' Ä«Å×°í¸®ÀÇ ´Ù¸¥ ±Û
[TileMap] TMS ¹× ±¸±Û ŸÀÏ¸Ê ÁÂÇ¥ È®ÀÎ »çÀÌÆ® (0) | 2018.10.02 |
---|---|
[MySQL] SELECT¹® DATE Á¶°Ç (¾îÁ¦, ¿À´Ã, ³»ÀÏ) (0) | 2016.09.08 |
[WINDOWS] Windows ¹èÄ¡ÆÄÀÏ ¹× Ä¿¸Ç´õ - ÆÄÀÏ»èÁ¦ (0) | 2016.09.06 |
[MySQL] SELECT¹® ÅؽºÆ®ÆÄÀÏ ÀúÀå (TXT, CSV) (0) | 2016.09.06 |
[mysql] MySQL ½ÃÀÛ, Á¾·á CMD ¸í·É¾î (0) | 2016.09.06 |
[PHP] Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource (0) | 2016.06.02 |