数据库常用命令DOS界面
-
启动和停止数据库
-
net stop mysql
-
net start mysql
-
上面的我不能使用,在计算机——属性——服务中找到MySQL是自动启动模式即可。
-
进入登录数据库 123456
-
conda activate tf36
-
mysql -h localhost -P 3306 -u root -p
-
退出
-
exit
-
显示当前数据库信息
-
show databases;
+--------------------+
| Database |
+--------------------+
| db_library |
| information_schema |
| mysql |
| performance_schema |
| sys |
| test |
+--------------------+
-
切换数据库
-
use test
Database changed
-
显示当前数据库下的表格
-
show tables;
+--------------------+
| Tables_in_test |
+--------------------+
| t_admission_ticket |
+--------------------+
-
显示其它(mysql)数据库下的表格
-
show tables from mysql;
-
查看当前数据库名
-
select database();
+------------+
| database() |
+------------+
| test |
+------------+
-
创建表stuinfo
-
create table stuinfo(
id int,
name varchar(20));
-
显示表属性
-
desc t_admission_ticket;
+------------------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+----------+------+-----+---------+-------+
| name | char(6) | NO | | NULL | |
| candidate_number | char(6) | NO | PRI | NULL | |
| id_number | char(18) | YES | | NULL | |
| gender | char(2) | YES | | NULL | |
| subject | char(20) | YES | | NULL | |
| address | char(50) | YES | | NULL | |
| time | char(50) | YES | | NULL | |
| seat | char(50) | YES | | NULL | |
| email | char(50) | NO | | NULL | |
+------------------+----------+------+-----+---------+-------+
-
插入表数据
-
insert into stuinfo (id,name) values(1,'john');
-
insert into stuinfo (id,name) values(2,'rose');
-
获取表数据
-
select * from stuinfo;
+------+------+
| id | name |
+------+------+
| 1 | john |
| 2 | rose |
+------+------+
-
修改数据
-
update stuinfo set name='lilei' where id=1;
-
select * from stuinfo;
+------+-------+
| id | name |
+------+-------+
| 1 | lilei |
| 2 | rose |
+------+-------+
-
delete from stuinfo where id=1;
-
select * from stuinfo;
+------+------+
| id | name |
+------+------+
| 2 | rose |
+------+------+
-
查看数据库版本
-
select version();
+-----------+
| version() |
+-----------+
| 8.0.21 |
+-----------+
-
或在dos下查看版本
-
mysql --version
-
mysql -V
语法规范:
-
不区分大小写,建议关键字大写,表名列名小写
-
命令最好以分号结尾
-
命令可以缩进和换行
-
注释文本
-
mysql> #select * from stuinfo;
-
mysql> -- select * from stuinfo;
-
mysql> /* select * from stuinfo; */