
MySQL
葛济维的博客
总想日更博客的小白
展开
-
myql如何查询有外键的表,实现多表联查?
举例子create table t_departments( id int primary key auto_increment, name varchar(50), location varchar(128))default charset = utf8;create table t_employees( id int primary key auto_increment, name varchar(64), salary double, d原创 2020-11-03 18:51:47 · 1887 阅读 · 1 评论 -
解决Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’问题
我的情况是重启了服务器后忘记再重启mysql只需要systemctl start mysqld启动Mysql就可备注:权限设置:chown mysql:mysql -R /var/lib/mysql初始化 MySQL:mysqld --initialize启动 MySQL:systemctl start mysqld查看 MySQL 运行状态:systemctl status mysqld...原创 2020-08-26 21:25:42 · 215 阅读 · 0 评论