Mysql数据导入导出

最新推荐文章于 2025-05-25 21:06:51 发布

原创最新推荐文章于 2025-05-25 21:06:51 发布 · 561 阅读

0 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

9 篇文章

订阅专栏

--更多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