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 · 1285 阅读 · 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 · 155 阅读 · 0 评论