Skip to content

Instantly share code, notes, and snippets.

@yukihirai0505

yukihirai0505/import.sql

Created December 11, 2015 13:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yukihirai0505/76fff4aa6a4ada62be0c to your computer and use it in GitHub Desktop.
Save yukihirai0505/76fff4aa6a4ada62be0c to your computer and use it in GitHub Desktop.
Download ZIP
CSVファイルのインポート
Raw
import.sql
LOAD DATA LOCAL INFILE 'CSVファイルのフルパス' INTO TABLE [テーブル名] FIELDS TERMINATED BY ',' ENCLOSED BY '"'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment