E:\mysql\mysql-5.5.40-winx64\bin>net start mysql
MySQL 服務正在啟動 .
MySQL 服務已經啟動成功。
進入數據庫
E:\mysql\mysql-5.5.40-winx64\bin>mysql -u root -p
修改密碼
E:\mysql\mysql-5.5.40-winx64\bin>mysqladmin -u root -p password 111111
顯示所有數據庫
mysql> show databases;
創建數據庫xiaomi
mysql> create database xiaomi;
顯示所有數據庫
mysql> show databases;
使用指定數據庫
mysql> use xiaomi;
顯示xiaomi中的表格
mysql> show tables;
創建名為tao的表格
mysql> create table tao(id int,itname nvarchar(100));
添加數據
mysql> insert into tao(id,itname) values(11,'ran')
查看全部數據
mysql> select * from tao;
條件搜索數據
mysql> select * from tao where id<3;
上傳txt到mysql(文件路徑用正斜杠)
mysql> load data local infile "E:/mysql/mysqltest.txt"
-> into table tao(id,itname);
mysql> select * from tao;顯示表格
+------+--------+
| id | itname |
+------+--------+
| 11 | ran |
| 21 | dan |
|1 | ww
|2 | ee
|3 | rr
| 4 | tt |
+------+--------+