load data

Posted on 2017-11-30 11:09  打杂滴  阅读(229)  评论(0编辑  收藏  举报

LOAD DATA INFILE 'D:\GX\\mm.txt' REPLACE INTO TABLE mm FIELDS TERMINATED BY ' '

// 以空格为分隔符插入数据,前提是mm.txt字段顺序要和表mm字段顺序一致,Navicat测试通过

 

Copyright © 2024 打杂滴
Powered by .NET 8.0 on Kubernetes