一、命令行操作:
1、本地登录:
mysql -u root -p
2、查看当前的业务逻辑数据库
show databases;
3、进入指定的逻辑数据库
use mysql;
4、查看当前数据库中所有的表:重点关注:user表
show tables;
5、查看表的具体结构
desc user;
6、执行SQL脚本文件:
source D:\sql\empdb.sql
7、查询语句
select * from emp;
select empno,ename from emp;
select * from emp where sal>=2000;
select * from emp where deptno=30;
select count(*) from emp;
select count(1) from emp;
8、模糊查询语句
select * from emp where ename like ‘%A%’;
select * from emp where ename like ‘__A%’;
9、添加语句
insert into emp(empno, ename, job, mgr, hiredate, sal, comm, deptno) values(7369, ‘SMITH’, ‘CLERK’, 79