一、数据库命令
1.1显示数据库命令
命令:mysql> show databases;
执行后:
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| test |
+--------------------+
6 rows in set (0.00 sec)
1.2 进入数据库
命令:mysql> use test;
执行后:
Database changed
1.3 显示表
命令:mysql> show tables;
执行后:
Empty set (0.00 sec)
命令:mysql> show tables from sys;
执行后:
+-----------------------------------------------+
| Tables_in_sys |
+-----------------------------------------------+
| host_summary |
.
.
.
+-----------------------------------------------+
101 rows in set (0.00 sec)
1.4 当前所在的库
命令:mysql> select database();
执行后:
+------------+
| database() |
+------------+
| test |
+------------+
1 row in set (0.00 sec)
1.5 创建表
命令:mysql> create table testinfo(
-> id int,
-> name varchar(20),
-> address varchar(30));
执行后:
Query OK, 0 rows affected (0.14 sec)
1.6 查看表结构
命令:mysql> desc testinfo;
执行后:
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
| name | varchar(20) | YES | | NULL | |
| address | varchar(30) | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
3 rows in set (0.03 sec)
1.7 查看表数据
命令:mysql> select * from testinfo;
执行后:
Empty set (0.03 sec)
1.8 插入数据
命令:mysql> insert into testinfo (id,name,address) values(1,'xiaohong','beijing');
执行后:
Query OK, 1 row affected (0.06 sec)
1.9 修改数据
命令:mysql> update testinfo set name='xiaowang' where id=2;
执行后:
Query OK, 1 row affected (0.05 sec)
Rows matched: 1 Changed: 1 Warnings: 0
1.10删除数据
命令:mysql> delete from testinfo where id=1;
执行后:Query OK, 1 row affected (0.05 sec)
1.11 查询数据库版本
方法一:
命令:mysql> select version();
+------------+
| version() |
+------------+
| 5.7.17-log |
+------------+
1 row in set (0.03 sec)
方法二:
命令:C:\Windows\system32>mysql --version
mysql Ver 14.14 Distrib 5.7.17, for Win64 (x86_64)
方法三:
命令:C:\Windows\system32>mysql -V
mysql Ver 14.14 Distrib 5.7.17, for Win64 (x86_64)
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)