Jaehyun Ahn JaehyunAhn
taeguk
/ poc.scala
Last active
August 19, 2019 01:20
Purely Functional Business Logic In Scala (https://taeguk2.blogspot.com/2019/08/purely-functional-business-logic-in.html)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| scalaVersion := "2.12.8" | |
| scalacOptions ++= Seq( | |
| "-Xfatal-warnings", | |
| "-Ypartial-unification" | |
| ) | |
| libraryDependencies += "org.typelevel" %% "cats-core" % "1.0.0" | |
| libraryDependencies += "org.typelevel" %% "cats-effect" % "1.3.1" | |
| libraryDependencies += "org.typelevel" %% "cats-effect-laws" % "1.3.1" % "test" | |
| */ |
gaerae
/ MySQL table into CSV file 1.sql
Last active
July 15, 2022 05:36
MySQL Table의 데이터를 CSV 형태로 내보내기 방법에는 여러가지가 있습니다.어떤 방법으로만 해야된다가 아닌 상황에 맞게 사용하는게 좋을 거 같습니다.4 가지 예시입니다.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT * FROM my_table | |
| INTO OUTFILE 'my_table.csv' | |
| CHARACTER SET euckr | |
| FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' | |
| ESCAPED BY '\\' | |
| LINES TERMINATED BY '\n' |