![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MYsql
文章平均质量分 84
我是一枚小白白
这个作者很懒,什么都没留下…
展开
-
DatabaseMetaData 底层调用的sql.
DatabaseMetaData dbmd = conn.getMetaData(); rs = dbmd.getColumns(null, "test", "%", null); 底层调用的sql: SHOW FULL TABLES FROM tes1 LIKE ‘%’ Query SHOW FULL COLUMNS FROM tt FROM tes1 LIKE ‘%’ SHOW FULL COLUMNS FROM a FROM tes1 LIKE ‘%’ Que原创 2020-07-17 21:45:18 · 283 阅读 · 0 评论 -
MYSql赋予用户权限、删除权限
创建用户 create user 用户名 identified by "密码"; 例子:create user test identified by "123456"; 赋予查询权限: grant select on test.v_a to usertest@'%'; FLUSH PRIVILEGES; ----刷新MySQL的系统权限相关表 查看当前用户(自己)权限: show grants; 查看其他 MySQL用户权限: show ...原创 2020-07-06 17:39:09 · 465 阅读 · 0 评论