摘要: db.GetConn().Model(&models.PurchaseContract{}). Joins("left join purchase_contract_order_rel on purchase_contract.trans_code = purchase_contract_order 阅读全文
posted @ 2022-01-14 17:34 Aqufish 阅读(116) 评论(0) 推荐(0)
摘要: 原因:个别路由会断掉闲置的tcp连接。 客户端方法: ➜ / vim ~/.ssh/config Host * ServerAliveInterval 60 阅读全文
posted @ 2021-12-18 00:39 Aqufish 阅读(57) 评论(0) 推荐(0)
摘要: //下载地址https://www.rabbitmq.com/which-erlang.htmlhttps://packagecloud.io/rabbitmq/erlang///下载链接curl -s https://packagecloud.io/install/repositories/rab 阅读全文
posted @ 2021-12-10 18:49 Aqufish 阅读(72) 评论(0) 推荐(0)
摘要: [root@dsjdasdjs]# service iptable status Redirecting to /bin/systemctl status iptable.service Unit iptable.service could not be found. 如下图: Centos8默认防 阅读全文
posted @ 2021-12-08 10:49 Aqufish 阅读(640) 评论(0) 推荐(0)
摘要: 造成报错原因有两个:1. mysql远程连接服务未开启被拒绝。 2. 服务器3306被防火墙阻挡掉,造成拒绝连接。解决方法如下: 1. 设置mysql远程访问权限 //连接mysql mysql -u root -p //赋予权限 mysql> GRANT ALL PRIVILEGES ON *.* 阅读全文
posted @ 2021-12-08 10:29 Aqufish 阅读(1691) 评论(0) 推荐(0)
摘要: //php默认函数similar_text(),对中文不友好 similar_text("Hello World","Hello Peter"); //7 <?php //phpinfo(); class LCS { var $str1; var $str2; var $c = array(); / 阅读全文
posted @ 2020-11-12 17:23 Aqufish 阅读(473) 评论(0) 推荐(0)
摘要: img.a { width: 200px; height: 400px; object-fit: cover; } 阅读全文
posted @ 2020-09-04 15:30 Aqufish 阅读(217) 评论(0) 推荐(0)
摘要: $longitude = 1111111; $latitude = 2222222; SELECT *,(st_distance (point ($longitude, $latitude),point(longitude,latitude) ) *111195) AS distance from 阅读全文
posted @ 2020-07-29 18:57 Aqufish 阅读(237) 评论(0) 推荐(0)
摘要: 1.UNIX_TIMESTAMP() $row = strtotime(date('Y-m-d', time()));//获取当天时间戳 DELETE FROM `table` where UNIX_TIMESTAMP(addtime) < '$row'//删除今天以前 2020-07-29 =》 阅读全文
posted @ 2020-07-29 18:48 Aqufish 阅读(518) 评论(0) 推荐(0)
摘要: 把字段 title 中 A 替换成 B update post set title = replace(title,'A','B') where title like '%AB%'; 阅读全文
posted @ 2020-06-23 11:14 Aqufish 阅读(419) 评论(0) 推荐(0)