我之前有个数据库已经有数据了,现在我改动了表的结构,在表里增加了一个字段,
升级数据库的时候,想把之前备份表的数据load到新的表结构(多了一个字段)
就报错了。
Row 1 doesn't contain data for all columns
导入的语句
load data infile 'c:\\table.txt' into table table;
高手有解决的方法吗?
升级数据库的时候,想把之前备份表的数据load到新的表结构(多了一个字段)
就报错了。
Row 1 doesn't contain data for all columns
导入的语句
load data infile 'c:\\table.txt' into table table;
高手有解决的方法吗?
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[CHARACTER SET charset_name]
[{FIELDS | COLUMNS}
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[LINES
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number LINES]
[(col_name_or_user_var,...)]
[SET col_name = expr,...]
把备份的文件所对应的字段名都带上。