mysql load data infile

来源:互联网 发布:梦里花落知多少2郭敬明 编辑:程序博客网 时间:2024/05/29 11:28

LOAD DATA INFILE 'D:/aa.txt' INTO TABLE aa FIELDS TERMINATED BY ','
LINES TERMINATED BY '/r/n' (col1,col2,...)
set col1=replace(uuid(),'',''),
col2='aa'

原创粉丝点击