时间戳

首页 > 解决方案 > 如何将 .txt 文件导入数据库？

mysql - 如何将 .txt 文件导入数据库？

问题描述

我有一个 .txt 文件，该文件正在保存更多 excel 表的数据。文本文件包含用逗号分隔的每一列的数据，它具有以下格式：

"GTCEN8B","GU_Bantrab_Diagonal_6_(1754)","0","WG1754B","PCS1900","704","01","258","17542","0","7","Normal_cell" ,"Normal_cell","","","","","OFF","","3","5","4","6","1","4","1 ","NO","NO","NO","4294967295","-","UNLOCK","ACTIVATED","Claro" "GTCEN8B","GU_Bantrab_Diagonal_6_(1754)","2","WG1754D ","GSM900","704","01","258","17544","5","5","Normal_cell","Normal_cell","","","","","OFF","","3","5","4","6","1","4","1","NO","NO","否","4294967295","-","解锁","已激活","Claro"

我想要做的是将文本文件引入数据库，按列分隔每个数据，以便在表中排列信息。但我不知道该怎么做，我只有 MySQL 的基本知识

如果您能帮助我，我将不胜感激。

标签： mysqldatabasefile

解决方案

在文件选项中使用简单的加载，如下所示

load data infile 'C:/filepath/files/data.csv' into table1 ENCLOSED BY '"' (C1,c2,...)

建议-在发布此问题之前，您应该进行一些谷歌搜索。您必须有许多解决方案，其中包含完整的工作示例，您应该将其翻译成您的解决方案。

推荐阅读