Shulou(Shulou.com)06/02 Report--

This article mainly introduces the mysql load how to import external csv format data, the article is very detailed, has a certain reference value, interested friends must read it!

Import external csv format data:

LOAD DATA LOCAL INFILE'C:\\ Users\\ Administrator\\ Desktop\\ aaa.csv' INTO TABLE `test`.`store _ buy_verify_ tb` CHARACTER SET 'gbk' FIELDS ESCAPED BY'\\ 'TERMINATED BY', 'ENCLOSED BY' "(`id`, `org_ id`, `check_ code`, `check_ name`, `use_ count`, `add_ by`, `add_ time`, `update_ by`, `update_ time`, `status`, `start_ time`, `end_ time`, `level`, `type`)

Csv data format:

Problems encountered:

CHARACTER SET 'gbk' started with' UTF-8', 'but reported an error:

Invalid utf8 character string:''

So just set it to 'gbk'.

The above is all the contents of the article "how to import external csv format data from load in mysql". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.