如何在第一个col为Auto Increment的情况下在mysql中加载DATA INFILE? [英] How to LOAD DATA INFILE in mysql with first col being Auto Increment?
本文介绍了如何在第一个col为Auto Increment的情况下在mysql中加载DATA INFILE?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当前,我们有一个与此类似的表:
Currently, We have a table similar to this:
---------------------
ID | AField | BField|
---------------------
ID为自动递增
如何创建CSV文件,以使数据库可以使用自动递增编号自动填充ID字段?
How do I create a CSV that can let the database auto populate the ID field with auto increment number?
我们尝试了以下CSV,但它不起作用:
We've tried the following CSV but it doesn't work:
afieldvalue, bfieldvalue (With Column definition but still doesn't work)
0,afieldvalue,bfieldvalue
NULL,afieldvalue,bfieldvalue
推荐答案
最好的方法是在CSV中包括2个非自动增量列,然后在装入数据中将ID列显式设置为NULL. infile语句.
The best thing to do is just include the 2 non-auto-increment columns in the CSV, and then explicitly set the ID column to NULL in the load data infile statement.
类似这样的东西:
LOAD DATA INFILE '/tmp/data.csv'
INTO TABLE your_table
FIELDS TERMINATED BY ','
(AField, BField)
SET ID = NULL;
这篇关于如何在第一个col为Auto Increment的情况下在mysql中加载DATA INFILE?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文