21.8.14MySQL学习笔记(2)
21.8.14笔记
显示数据库:show databases;
每条命令的结尾,用英文的 ; 或者 \g 隔开
show databases;输入后,显示如下:
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.01 sec)
#前三个数据库不能动
#| information_schema | ——————保存源数据信息
#| mysql |
#| performance_schema | ——————保存一下姓名信息(参数)
#| test | ——————测试数据库,可直接在里边增删改数据
进入相应的数据库:use + 库名;(例如:use test;)
mysql> use test
Database changed
显示库中的表格:show tables;
#也可以用:show tables from + 库名(例如:show tables from test;)
mysql> show tables;
Empty set (0.00 sec)
mysql> show tables from test;
Empty set (0.00 sec)
查询目前所在位置:select database();
#该操作会显示目前所在位置
mysql> select database();
+------------+
| database() |
+------------+
| test |
+------------+
1 row in set (0.00 sec)
建表:create table + 表名;
#这里需要在把表里的信息给列出来,比如:
#create table wangdachui(
#id int,#(int表示列)
#name varchar (20) );#(varchar表示字符串)
mysql> create table wangdachui(
-> id int,
-> name varchar(20));
Query OK, 0 rows affected (0.01 sec)
查看表的结构:desc + 表名;(例如:desc wangdachui;)
mysql> desc wangdachui
-> ;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| name | varchar(20) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.02 sec)
查看表内的数据:select * from + 表名;(例如:select * from wangdachui;)
mysql> select * from wangdachui;
Empty set (0.00 sec)
#由于表中没有数据,所以显示是empty
在表内加入数据:insert into + 表名(id,name) values(1,'john');
#输入上面的内容会在表里加入john,标号是1
mysql> insert into wangdachui (id,name) values(1,'john');
Query OK, 1 row affected (0.00 sec)
mysql> insert into wangdachui (id,name) values(2,'rose');
Query OK, 1 row affected (0.01 sec)
修改表中数据:update + 表名 set name='lilei' where id=1;
#这个操作会把ID为1的那一行里name列的内容更改为lilei
mysql> update wangdachui set name='lilei' where id=1;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
删除表中数据:delete from + 表名 + where id=1;
#例如:delete from wangdachui where id=1;
#这个操作会把相应位置的数据删除掉
mysql> delete from wangdachui where id=1;
Query OK, 1 row affected (0.01 sec)
mysql> select * from wangdachui;
+------+------+
| id | name |
+------+------+
| 2 | rose |
+------+------+
1 row in set (0.00 sec)