👌

MySQLへcsvをloadする方法

1 min read
  load data infile 'account.csv' into table authapi.account
    fields
      terminated by ','
      enclosed by '\\"'
      escaped by '\\'
  lines
    terminated by '\\\\n'

Discussion

ログインするとコメントできます