supramolecular的博客

查询排行榜 SELECT t.*, @rank_num := @rank_num + 1 AS rank_num FROM (SELECT @rank_num := 0) r, (SELECT nickname, type, wx_nickname, wx_avatar, share_viewers_count FROM `live_audiences` where video_id = ...

mysql -uroot -p use mysql; grant all privileges on 库名.表名 to '用户名'@'IP地址' identified by '密码' with grant option; flush privileges; 此外还需更改设置 cd /etc/mysql/mysql.conf.d sudo vim mysqld.cnf bind-addre...