情景描述:在将大量数据导入数据库时,最后一列需要置为默认值:10,因为要求脚本自动执行,不考虑将导入文件进行修改后导入,直接在不修改文件的情况下完成
完成分析:将导入参数修改,增加CONSTANT "10",将改字段全部置为默认值10
示例:
LOAD DATA
INFILE "test1bak.csv"
append into table test1bak
FIELDS TERMINATED BY ","
trailing nullcols
(
IP1,
IP2,
IP3,
IP4,
IP5 CONSTANT "10"
)