Macbook 电脑意外关机重启mysql链接不上的解决办法 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)解决办法sudo mysql.server stop sudo mysql.server start// Homebrew 安装MySQL想启动和关闭服务需要使用以下命令 // 启动 mysql, 并设置为开机启动 brew services start mysql // 关闭 mysql brew services stop mysql // 重启 mysql brew services restart mysql

MacBook pro 新版系统如何设置vpn支持pptp类型 No bibi show code先 cd到你的maccd /etc/ppp/peers vim vpn.pplware //将下面的内容写进去保存{message}根据你自己的信息进行更改{/message}plugin PPTP.ppp noauth # logfile /tmp/ppp.log remoteaddress "你的vpn地址" user "用户名" password "密码" redialcount 1 redialtimer 5 idle 1800 # mru 1368 # mtu 1368 receive-all novj 0:0 ipcp-accept-local ipcp-accept-remote # noauth refuse-eap refuse-pap refuse-chap-md5 hide-password mppe-stateless mppe-128 # require-mppe-128 looplocal nodetach # ms-dns 8.8.8.8 usepeerdns # ipparam gwvpn defaultroute debug 开启vpnsudo pppd call vpn.pplware关闭vnpsudo pkill pppd

jquery 设置缓存 解决ajax请求 js被添加时间戳问题 暂无简介

此内容被密码保护 加密文章，请前往内页查看详情

Mysql联表查询按照某个字段分组并取每组的前8条数据 SELECT t1.* FROM ( SELECT sqrt( (10 - ec.l) * (10 - ec.l) + (10 - ec.a) * (10 - ec.a) + (10 - ec.b) * (10 - ec.b) ) AS distValue, em. NAME material_name, ec.* FROM ea_color AS ec JOIN ea_material AS em ON em.id = ec.material_id WHERE ec.delete_time IS NULL AND ec.material_id IN (0, 1, 2, 3, 4, 5, 6, 7, 8, 8) ) AS t1 WHERE ( SELECT count(*) + 1 FROM ( SELECT sqrt( (10 - ec.l) * (10 - ec.l) + (10 - ec.a) * (10 - ec.a) + (10 - ec.b) * (10 - ec.b) ) AS distValue, em. NAME material_name, ec.* FROM ea_color AS ec JOIN ea_material AS em ON em.id = ec.material_id WHERE ec.delete_time IS NULL AND ec.material_id IN (0, 1, 2, 3, 4, 5, 6, 7, 8, 8) ) AS t2 WHERE t1.material_id = t2.material_id AND t2.distValue < t1.distValue ) <= 8 AND t1.delete_time IS NULL ORDER BY t1.material_id, t1.distValue