MySQL数据库的19个常用命令
程序员文章站
2022-06-22 20:33:31
MySQL常用名令1.登录mysql –h 主机名 –u用户名 –p密码2.显示所有数据库show databases;3.进入指定数据库use mysql;4.查看库中所有表show tables; //查看所有表show tables from mysql; //查看其它库中所有表5.查看当前库select database();6.新建一个数据库create database spark;7.查看版本C:/ > mysql -version...
MySQL常用名令
1.登录
mysql –h 主机名 –u用户名 –p密码
2.显示所有数据库
show databases;
3.进入指定数据库
use mysql;
4.查看库中所有表
show tables; //查看所有表
show tables from mysql; //查看其它库中所有表
5.查看当前库
select database();
6.新建一个数据库
create database spark;
7.查看版本
C:/ > mysql -version //进入mysql客户端之前
C:/ > mysql -V //进入mysql客户端之前
mysql > select version(); //进入mysql客户端之后
8.建表
mysql > create table customer(id varchar(30),age int, name varchar(30),birthday date);
9.查看表结构
desc customer;
10.查看表
select*from customer;
11.查询特定列
select id,name,sex from student;
12.查询数据并进行过滤
select id,name,sex from student where id=>1003;
13.运算符查询
select id,name,sex from student where age >=18 and age <=35;
select id,name,sex from student where age between 18 and 35;
14.查询变种
mselect * from student where age =18 or age =35 or age =23
mselect * from student where age in (18,23,35);
select * from student where name like '%小%';//%匹配任意多个字符,_只匹配一个字符
select * from student where name like '_明%';
select * from student where email is null;
select * from student where email is not null;
select * from student order by age ; //升序
select * from student order by age desc ; //降序
15.插入数据
insert into student(id,name)values(1001,'小明');//插入 varchar 或 date 型的数据要用 单引号 引起来
16.修改表
update student set name='小红' where id=1001;
17.删除表记录
delete from student where id =1001;
18.删除表
drop table customer;//删除表
drop database girls;//删除数据库
19.退出
mysql > exit;
ctrl+C;
quit;
本文地址:https://blog.csdn.net/qq_49516927/article/details/107675515
上一篇: OA系统数据库Mysql服务无法启动