摘要:
1.建表插入数据#创建COMPANY表,数据内容如下:DROP TABLE COMPANY;CREATE TABLE COMPANY(ID INT PRIMARY KEY NOT NULL,NAME TEXT NOT NULL,AGE INT NOT NULL,ADDRESS CHAR(50),SA 阅读全文
摘要:
1、sys用户登录查询sys的权限和普通权限。 sys用户权限 SQL> select * from user_sys_privs where privilege like upper('%DATABASE LINK%'); 普通用户权限 SQL> select * from user_sys_pr 阅读全文
摘要:
1、编辑mariadb的yum源,内容从官方获取 https://mariadb.org/download/?t=repo-config&d=CentOS+7+%28x86_64%29&v=10.5&r_m=blendbyte [root@server yum.repos.d]# vim maria 阅读全文
摘要:
# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html# *** DO NOT EDIT THIS FIL 阅读全文