Mysql数据导入导出

最新推荐文章于 2024-02-17 18:52:41 发布

tyt叮当tyt

最新推荐文章于 2024-02-17 18:52:41 发布

阅读量538

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/suwing6406029/article/details/38944797

版权

mysql 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

--更多load data可以使用help load data
LOAD DATA INFILE 'C:\\Users\\Administrator\\Desktop\\1.TXT' INTO TABLE ME_FILE_UPLOAD FIELDS TERMINATED BY ','
(FILE_ID,FILE_NAME,FILE_TYPE,FILE_SIZE,UPLOAD_DATE,UPLOAD_TIME,UPLOADER)
--默认分隔符为tab
LOAD DATA INFILE 'C:\\Users\\Administrator\\Desktop\\3.TXT' INTO TABLE ME_FILE_UPLOAD

SELECT * INTO OUTFILE 'C:\\Users\\Administrator\\Desktop\\2.TXT' FIELDS TERMINATED BY ',' FROM me_file_upload
SELECT * INTO OUTFILE 'C:\\Users\\Administrator\\Desktop\\3.TXT' FROM me_file_upload