MySQL - LOAD DATA INFILE上的多个集合 [英] MySQL - Multiple set on LOAD DATA INFILE
本文介绍了MySQL - LOAD DATA INFILE上的多个集合的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个 table_name
:
否|名称| Inserted_Date | Inserted_By
===================================
然后我就像这样写文件name.csv
no,name
1,jhon
2,alex
3,steve
我想使用这样的语法加载这些文件
table_name
:LOAD DATA INFILE'name.csv'INTO TABLE table1
由','
终止的字段由'\\\
'终止的字符串
IGNORE 1 LINES
?
问题是,我应该放在
?
所以我可以存储这样的数据:否|名称| Inserted_Date | Inserted_By
===================================
1 | jhon | sysdate()| me
2 | ales | sysdate()| me
3 | steve | sysdate()| me
解决方案c> inserted_date 和
inserted_by
已存在。如果没有,您可以在运行LOAD DATA INFILE
之前添加它们:LOAD DATA INFILE'name.csv'INTO TABLE table1
由','
终止的字段由'\\\
'终止的行
IGNORE 1 LINES
(@no,@name )
set
no = @no,
name = @name,
inserted_date = now(),
inserted_by ='me'
I've a
table_name
like this:No | Name | Inserted_Date | Inserted_By =====================================
and then I've file name.csv like this
no,name 1,jhon 2,alex 3,steve
I want to load these file
table_name
using syntax like this:LOAD DATA INFILE 'name.csv' INTO TABLE table1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES ???
the question is, what should I put on
???
so I can store data like this:No | Name | Inserted_Date | Inserted_By ===================================== 1 | jhon | sysdate() | me 2 | ales | sysdate() | me 3 | steve | sysdate() | me
解决方案I do not understand if columns
inserted_date
andinserted_by
already exists in your table. If no than you can add them before runingLOAD DATA INFILE
:LOAD DATA INFILE 'name.csv' INTO TABLE table1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES (@no, @name) set no = @no, name = @name, inserted_date = now(), inserted_by = 'me'
这篇关于MySQL - LOAD DATA INFILE上的多个集合的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文