1. 登录本地mysql:
1. 登录本地mysql:
mysql -u 用户名 -p
mysql -u root -p 先输入,回车
然后提示输入密码,回车即可;
2. 查看库
show databases; 回车
3. 使用库
use 库名;回车
4. 查询存储
SHOW PROCEDURE STATUS where db = ‘库名’ and type
= ‘PROCEDURE’;
show create procedure 存储名;
5. 查询视图
show table status where comment=‘view’;
6. 执行存储查询
set @userId = ‘’;
set @pageIndex = 1;
set @pageSize = 10;
call 存储名(@userId,@pageIndex,@pageSize);
7. 查询表
show table status where comment!=‘view’ and Name like ‘eform_%’
select table_name from information_schema.tables where TABLE_NAME like ‘%eform_%’