Files
StudyDiary/20-我的收藏夹/21-浏览器收藏/开发网站/20230709/mysql直接通过phpmyadmin导入csv文件需要注意的地方_myphpadmin 插入csv_漏刻有时的博客-CSDN博客.md
CrazyJasonwell fb40c9b109 add all
2025-10-25 20:35:10 +08:00

17 lines
689 B
Markdown
Executable File
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
---
raindrop_id: 670464365
created: 2025-08-30T11:44
updated: 2025-09-22T13:26
---
# Metadata
Source URL:: https://blog.csdn.net/weixin_41290949/article/details/109308665
---
# mysql直接通过phpmyadmin导入csv文件需要注意的地方_myphpadmin 插入csv_漏刻有时的博客-CSDN博客
文章浏览阅读695次。mysql直接通过phpmyadmin导入csv文件excle编辑好文件,需要日期和时间类型,必须是两位数;保存csv后,需要用记事本打开,再次另存为"utf-8"编码,默认保存的是ANSI编码;phpmyadmin选择“CSV using LOAD DATA”格式;字段分隔符和CSV文件一致;Done!..._myphpadmin 插入csv
## Highlights