加载数据到文件问题

发布于 2024-10-15 04:58:36 字数 295 浏览 8 评论 0原文

我目前在查询中使用 LOAD DATA INFILE，但我不确定如何分离数据

数据采用以下格式名字：姓氏

$this->db->query("LOAD DATA INFILE 'names.txt' 
                  INTO names firstname lastname 
                FIELDS TERMINATED BY ':'");

我将如何使用它从文本文件中获取数据并分割名字：姓氏将名字插入名字 &姓氏变成姓氏？

原文

I'm currently using LOAD DATA INFILE in my query, but I am not sure how to separate the data

The data is in the following format firstname:lastname

$this->db->query("LOAD DATA INFILE 'names.txt' 
                  INTO names firstname lastname 
                FIELDS TERMINATED BY ':'");

How would I use this to take the data from the text file and split firstname:lastname to insert firstname into firstname & lastname into lastname?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

方觉久 2024-10-22 04:58:36

我假设您的表名称是 names。在这种情况下，查询应该是：

"LOAD DATA INFILE 'names.txt' 
    INTO TABLE names
    FIELDS TERMINATED BY ':' 
    (firstname, lastname)"

那么当然你必须执行该语句。

还要注意换行符、字段包围符和字段转义符，您可以为其指定 [LINES] TERMINATED BY、[FIELDS] ENCLOSED BY 和 [FIELDS ] ESCAPED BY 分别（方括号表示您仅指定 LINES 或 FIELDS 一次）。

I'm assuming your table name is names. In which case the query should be:

"LOAD DATA INFILE 'names.txt' 
    INTO TABLE names
    FIELDS TERMINATED BY ':' 
    (firstname, lastname)"

Then of course you have to execute the statement.

Also take care of newline characters, field enclosure characters and field escape characters, for which you specify [LINES] TERMINATED BY, [FIELDS] ENCLOSED BY and [FIELDS] ESCAPED BY respectively (square brackets meaning that you only specify LINES or FIELDS once).

回复收藏 0 原文

~没有更多了~