mysql的load语法
2019-07-23 本文已影响0人
想旅游的程序员
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] /
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[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,...)]
实例：load data infile "c:/users/xm/1.txt" into table user fields terminated by ":" ignore 1 lines (name,pwd)
