1. mysql¿¡¼ »ç¿ëÇÏ´ø Ä÷³ÀÇ »çÀÌÁî°¡ Ƽº£·Î ³Ñ¾î°¥¶§ Â÷ÀÌ°¡ ³²..
³Ñ±â´Ù º¸¸é µ¿ÀÏÇÑ »çÀÌÁî·Î º¯°æÇßÀ»¶§ max °ªÀÌ Á¸ÀçÇÏ´Â °æ¿ì ´Ù ¿¡·¯ ³².
1. DBEAVER »ç¿ë
2. MYSQL --> Ƽº£·Î Å×ÀÌºí ³»º¸³»±â
¾ÈµÇ´Â°æ¿ì.
1. SALAST19.CSV ÆÄÀÏÀ» »ý¼º ( MYSQL¿¡¼ )
SELECT *
INTO OUTFILE 'slast19.csv'
CHARACTER SET euckr
FIELDS TERMINATED BY '$'
ENCLOSED BY ''
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM world.sLast2019;
;
-- ÆÄÀÏ »ý¼ºÀå¼Ò : C:\ProgramData\MySQL\MySQL Server 5.7\Data
-- ÆÄÀϸí : 'slast19.csv'
-- ÇÑ±Û º¯È¯ : CHARACTER SET euckr
-- ÇÊµå ±¸ºÐ°ª : FIELDS TERMINATED BY '$'
2. µ¥ÀÌŸ ÀÔ·Â
DBEAVER »ç¿ë
CSV µ¥ÀÌŸ °¡Á®¿À±â ½ÇÇà