共 3 篇文章 |
|
mysql基础知识摘要添加外键:alter table sys_roles_permissions add constraint fk_rid foreign key(permission_id) references sys_permissions(id) on delete cascade on update cascade;查看外键:select * from information_schema.table_constraints t where t.table_name = ''sys_roles_permissions'' and constraint_t... 阅32 转0 评0 公众公开 17-06-20 17:09 |
MySQL 5.7.17安装。mysql]default-character-set=utf8[mysqld]port = 3306basedir=D:\ruanjian\mysql-5.7.17-winx64datadir=D:\ruanjian\mysql-5.7.17-winx64\datamax_connections=200character-set-server=utf8default-storage-engine=INNODBexplicit_defaults_for_timestamp=true.变量值:“D:\mysql\mysql-5.7.17-winx64”6.以管理员身份运... 阅184 转0 评0 公众公开 17-02-27 14:39 |
mysql 出现 ERROR 1045 (28000): Access denied for user ''root''@''localhost'' (using password: NO)基本安装流程:下载mysql安装包,解压放在特定的目录下。 阅109 转1 评0 公众公开 17-02-23 17:11 |