Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 请问一个有关问题，怎么把txt导入数据库

请问一个有关问题，怎么把txt导入数据库

WBOY
Release： 2016-06-13 11:28:58
Original
892 people have browsed it

请教一个问题，如何把txt导入数据库
假[i]设现在拿到一个CSDN所有用户和密码的txt，里面有30W的数据，第一列是用户名，第二列是密码，第三列是邮箱。

然后再拿到一个天涯的txt，但是第一列是邮箱，第二列是用户名，第三列密码。
还有更多排列不一致的txt。

我想做一个通用的导入程序，如何能使不同的txt文件都能按照 “用户名-密码-邮箱”这样的方式存入数据库相应的字段呢，这样就能方便的在数据库查询，谢谢！

Related labels：
character database nbsp txt
source：php.cn
Previous article：序列化过的数据,经过post方式传值,数据消失 Next article：wordpress查看站点时显示目录,该怎么解决
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1429
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1284
PX automatic conversion to REM error  <style>html {   font-size: calc(100vw / 3.75);      }...
From 2024-04-16 09:34:16
0
0
4687
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template