Loading Data into a Table;MySQL从本地向数据库导入数据
2024-09-25 14:46:59
- 在localhost中准备好了一个test数据库和一个pet表:
mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | test | +--------------------+ rows in set (0.01 sec) mysql> USE test Database changed mysql> SHOW TABLES; +----------------+ | Tables_in_test | +----------------+ | pet | +----------------+ row in set (0.01 sec)
- 在电脑中准备一个pet.txt文件,里面包含想要导入到pet表的数据。(文件中一行代表一条数据,一条数据中的属性用Tab键隔开)
- 向pet表载入pet.txt中的数据:
mysql> LOAD DATA LOCAL INFILE 'E:\Desktop\pet.txt' INTO TABLE pet; ERROR (): The used command is not allowed with this MySQL version
ERROR原因:服务器端,local_infile默认开启,客户端local_infile默认关闭,因此用的时候需要打开它
mysql> SHOW VARIABLES like 'local_infile'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | local_infile | OFF | +---------------+-------+ row warning (0.04 sec)
开启local_infile:(开启后,再次执行SHOW VARIABLES like 'local_infile'会看到Value为ON)
mysql> SET GLOBAL local_infile=ON; Query OK, rows affected (0.00 sec)
重新载入:
mysql> LOAD DATA LOCAL INFILE 'E:\Desktop\pet.txt' INTO TABLE pet; ERROR (HY000): - No such file or directory)
ERROR原因:路径应使用'/' , 重新载入:
mysql> LOAD DATA LOCAL INFILE 'E:/Desktop/pet.txt' INTO TABLE pet; Query OK, rows affected, warnings (0.02 sec) Records: Deleted: Skipped: Warnings:
载入完毕,查看载入成功后的pet表: ψ(`∇´)ψ
mysql> select * from pet; +----------+--------+---------+------+------------+------------+ | name | owner | species | sex | birth | death | +----------+--------+---------+------+------------+------------+ | | | | | | | | +----------+--------+---------+------+------------+------------+ rows in set (0.00 sec
最新文章
- AngularJs项目文件以及文件夹结构
- 问你觉得iOS7为什么要扁平化,扁平化和之前的比有什么优势
- hihoCoder 1432 : JiLi Number(吉利数)
- Cardinal样条曲线的Javascript实现(理论篇)
- UVA 11809 - Floating-Point Numbers
- assign,copy,strong,weak,nonatomic的理解
- 内置函数----整理、例题 、xmin
- 由索引节点(inode)爆满引发的问题
- ios app的真机调试与发布配置
- WPF常用数据绑定控件集合
- ORCL_INSTALL_WIN10
- Oracle 学习笔记 19 -- 触发器和包浅析(PL/SQL)
- 【转】Linux查看CPU和内存使用情况
- HDOJ 1755 - A Number Puzzle 排列数字凑同余,状态压缩DP
- groovy学习(四)io
- wex5 设置文本居中或图片居中
- Win10+QT5.7.1搭建opencv开发环境
- 12月16日广州.NET俱乐部下午4点爬白云山活动
- 使用Github Composer Packagist编写及发布扩展包
- (24)How generational stereotypes hold us back at work