1、显示当前数据库服务器中的数据库列表
mysql> SHOW DATABASES;
2、显示数据库中的数据表:
mysql> USE 库名;
mysql> SHOW TABLES;
3、显示use的数据库名:
mysql> SELECT DATABASE();
4、建立数据库:
mysql> CREATE DATABASE 库名;
5、删除数据库:
mysql> DROP DATABASE 库名;
6、导入.sql文件命令:
mysql> USE 数据库名;
mysql> SOURCE d:/mysql.sql;
也可以在DOS环境下键入以下命令进行导入:
mysql -uroot -proot databasename < databasename.sql
7、使用这个数据库
使用命令:use flight_analysis;
8、导入数据库
load data infile ‘D:/test1.csv’ --CSV文件存放路径
9、导入表
格式:load data infile “文件路径+文件” into table [tablename] fields terminated by ','
导入不含中文名的表步骤:
1)LOAD DATA LOCAL INFILE ‘D:\TEST\175.csv’ (文件路径)
2)INTO TABLE TEST 表名)
3)CHARACTER SET utf8
4)FIELDS TERMINATED BY ‘,’
5)ENCLOSED BY ‘"’
6)LINES TERMINATED BY ‘\n’
7)ignore 1 lines;
导入数据中包含中步骤:
1)load data infile ‘D:/test1.csv’ --CSV文件存放路径
2)into table test character set gb2312 --要将数据导入的表名
3)fields terminated by ‘,’ optionally enclosed by ‘"’ escaped by ‘"’
4)lines terminated by ‘\r\n’;
5) ignore 1 lines;
10、导出查询或表
1 select * from 表名
2 into outfile ‘导出路径\test.csv’
3 fields terminated by ‘,’
4 optionally enclosed by ‘"’
5 escaped by ‘"’
6 lines terminated by ‘\n’;