mysql -uroot -p
show databases;
use scm;
show tables;
show procedure status;
其他命令:
SHOW VARIABLES LIKE 'event_scheduler'; 看事件是否启动【用于定时执行时候检查】
SET GLOBAL event_scheduler...
创建视图
sql>create view 视图名 as select语句;
修改视图并添加别名
sql>create or replace view empvu10 (employee_number,employe_name,job_title) as select empno,ename,job from emp where deptno=1...