<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[helodd 的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/helodd</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; helodd]]></copyright><item><title><![CDATA[FAS防火设计模块箱规范小结]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/144644592</link><guid>https://blog.youkuaiyun.com/helodd/article/details/144644592</guid><author>helodd</author><pubDate>Sun, 22 Dec 2024 12:15:52 +0800</pubDate><description><![CDATA[1、每个箱应设计有短路隔离模块，一般设计在离回路线最近的位置。3、带控制的模块，应留有2个模块位置，方便下面的接线端子够用。2、水流指示，亮灯等应放在1#,2#方便识别。]]></description><category></category></item><item><title><![CDATA[sqlite在非主键创建一个自增字段]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/137328454</link><guid>https://blog.youkuaiyun.com/helodd/article/details/137328454</guid><author>helodd</author><pubDate>Wed, 03 Apr 2024 09:38:28 +0800</pubDate><description><![CDATA[sqlite 自增比较奇葩，自增字段必须建在主键上，但主键很重要。不是每种情况都是给自增去做。比如要实现replace into 时， 要主键作为更新标识。1、建立一个主表，主表的ID是自增ID，但不是主键。而billno 是主键。3、在base_user 表上创建触发器，从而实现ID的自增。2、选创建一个用于记录自动ID的辅助表。3、向用户表添加数据试试。]]></description><category></category></item><item><title><![CDATA[Nginx+php-fpm对上传附件的设置]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/129078584</link><guid>https://blog.youkuaiyun.com/helodd/article/details/129078584</guid><author>helodd</author><pubDate>Fri, 17 Feb 2023 09:35:44 +0800</pubDate><description><![CDATA[Nginx+php-fpm对附件默认的设置都很小， 需要改动配置实现想的附件尺寸。修改nginx.conf和php.ini实现。file_uploads = on                  #默认Off ，改为 On。#设置成nginx的client_max_body_size。#设置成nginx的client_max_body_size。]]></description><category></category></item><item><title><![CDATA[mariadb数据库删除恢复过程]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/128866000</link><guid>https://blog.youkuaiyun.com/helodd/article/details/128866000</guid><author>helodd</author><pubDate>Fri, 03 Feb 2023 14:49:55 +0800</pubDate><description><![CDATA[不作不死，不小心使sqlyog导数据选错服务器。把生产机的数据全部删除了。可怕的数据没有做其他过多的备份，只是每天自动crontab 备份。快， 赶紧看看日备份有没有。马上切换到备份目录，喜出望外，每天生成的文件一个个都在。取最后一个 mysql-bin.000045日志文件，并查看一个它的相关事件。使用mysqlbinlog 从日志中取得缺少备份的数据并还原。使用FLUSH LOGS 切断最后日志文件的继续记录。从每天备份的文件回到到现数据库。记录执行错误的执行时间。到此，数据已完全还原。]]></description><category></category></item><item><title><![CDATA[CocoaPodsg更换国内源提高下载速度]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/127592356</link><guid>https://blog.youkuaiyun.com/helodd/article/details/127592356</guid><author>helodd</author><pubDate>Sat, 29 Oct 2022 21:28:02 +0800</pubDate><description><![CDATA[成功更换， pod install 的时候明显会快了。也很少出现超时而中断的情况。]]></description><category></category></item><item><title><![CDATA[iMAC 2013机器从mac0s10.5升级安装macos12.6 Monterey]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/127400891</link><guid>https://blog.youkuaiyun.com/helodd/article/details/127400891</guid><author>helodd</author><pubDate>Wed, 19 Oct 2022 09:26:45 +0800</pubDate><description><![CDATA[iMAC 2013机器从mac0s10.5升级安装macos12.6 Monterey]]></description><category></category></item><item><title><![CDATA[react-native 使用高德SDK取得位置信息]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/126072624</link><guid>https://blog.youkuaiyun.com/helodd/article/details/126072624</guid><author>helodd</author><pubDate>Sat, 30 Jul 2022 15:19:59 +0800</pubDate><description><![CDATA[meta-dataandroidname="com.amap.api.v2.apikey"androidvalue="key">//开发者申请的key加入高德androidkey。4、封装Geo.js。]]></description><category></category></item><item><title><![CDATA[React Native 的JS文件中的TypeScript语法报错]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/124590638</link><guid>https://blog.youkuaiyun.com/helodd/article/details/124590638</guid><author>helodd</author><pubDate>Thu, 05 May 2022 15:56:01 +0800</pubDate><description><![CDATA[vscode 编辑react Native 项目的JS文件TypeScript语法检查错误]]></description><category></category></item><item><title><![CDATA[php在UTF-8编码文件下strlen取中文字串长度不正确]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/116536803</link><guid>https://blog.youkuaiyun.com/helodd/article/details/116536803</guid><author>helodd</author><pubDate>Wed, 23 Mar 2022 16:28:15 +0800</pubDate><description><![CDATA[1、选择数据表的字符集改为正确的字符集

ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

2、更新内容转换为正确的字符集

ALTER TABLE ht_retax CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
...]]></description><category></category></item><item><title><![CDATA[javascript 使用round（）函数只保留指定位数而不会四舍五入]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/120019788</link><guid>https://blog.youkuaiyun.com/helodd/article/details/120019788</guid><author>helodd</author><pubDate>Tue, 31 Aug 2021 15:49:51 +0800</pubDate><description><![CDATA[let myvalue= round(27900 * 18.09565,2) = 504868.63, 而实际值为： 504868.635



这时候如进行四舍五入取2位正确的数？



只能先取3位，再取2位才正确:

let myvalue= round(27900 * 18.09565,3) ;

myvalue= round(myvalue，2）;
...]]></description><category></category></item><item><title><![CDATA[mysql(mariadb)使用integrals作为字段名导致更新计算错误]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/117747202</link><guid>https://blog.youkuaiyun.com/helodd/article/details/117747202</guid><author>helodd</author><pubDate>Wed, 09 Jun 2021 16:30:54 +0800</pubDate><description><![CDATA[通过触发器使用如下语句：



UPDATE low_user SET integrals=integrals+@pp, aa=aa+@pp WHERE billno=old.admin ;
]]></description><category></category></item><item><title><![CDATA[LNMP配置支持Redis踩过的坑]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/115660076</link><guid>https://blog.youkuaiyun.com/helodd/article/details/115660076</guid><author>helodd</author><pubDate>Tue, 13 Apr 2021 11:55:12 +0800</pubDate><description><![CDATA[1、下载扩展支持

$wget http://download.redis.io/releases/redis-5.2.2.tar.gz

2、解压

$tar xzvf redis-5.2.2.tar.gz

3、生成配置

$cd redis-5.2.2

$phpize

4、编译安装

$sudo ./configure --with-php-config=/usr/local/php/bin/php-config

$make

$make install

5、修改php.ini 添加扩展支持.]]></description><category></category></item><item><title><![CDATA[docker 容器与宿主机的时间同步]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/112968486</link><guid>https://blog.youkuaiyun.com/helodd/article/details/112968486</guid><author>helodd</author><pubDate>Thu, 21 Jan 2021 17:53:09 +0800</pubDate><description><![CDATA[# docker exec -it 8259860d43e9/bin/bash

root@8259860d43e9:# date //显示容器的当前时间

root@8259860d43e9:# cp/usr/share/zoneinfo/Asia/Shanghai/etc/localtime&amp;&amp;echo'Asia/Shanghai'&gt;/etc/timezone

root@8259860d43e9:# exit

# docker restart 8259860d43...]]></description><category></category></item><item><title><![CDATA[Fedora 33 无法SSH无法登录Access Denied的处理办法]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/109470680</link><guid>https://blog.youkuaiyun.com/helodd/article/details/109470680</guid><author>helodd</author><pubDate>Tue, 03 Nov 2020 15:33:50 +0800</pubDate><description><![CDATA[1、vi /etc/ssh/sshd_config



#PermitRootLogin 。。。

改为

PermitRootLogin yes



2、servicerestart ssh



3、SSH重新连登完成
]]></description><category></category></item><item><title><![CDATA[一个php获取文件夹路径文件列表的函数]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/109445654</link><guid>https://blog.youkuaiyun.com/helodd/article/details/109445654</guid><author>helodd</author><pubDate>Mon, 02 Nov 2020 11:43:30 +0800</pubDate><description><![CDATA[在网上找了一下PHP获得文件列表的代码，发现有问题，不太好用，做了一下改进，完善了扩展过滤、子目录递归等功能。

1、上函数


/*
 * 获取指定目录下指定文件后缀的函数
 * @$path   文件路径
 * @$ext    文件后缀名，默认为false为不指定，如果指定，请以数组方式传入
 * @$filename   使用时请提前赋值为空数组
 * @$recursive  是否递归查找，默认为false
 * @$baseurl    是否包含路径，默认包含
 */
function ge..]]></description><category></category></item><item><title><![CDATA[SQL从杂乱的字符串字段中统计数字部份的最大值]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/109327294</link><guid>https://blog.youkuaiyun.com/helodd/article/details/109327294</guid><author>helodd</author><pubDate>Wed, 28 Oct 2020 10:16:45 +0800</pubDate><description><![CDATA[有一组如以下字段的值，杂乱无章，如何使用SQL提取它的数值部份的最大值呢？
17002
17003
999-PCBA
A010-B000
a1124
aqed03
B010-0237001
F010-027PE1021
F010-3300209
F010-80102251
F010-998000-000



办法如下：

1、创建一函数，过虑字段中的数值部份

create function dbo.GetNoFromStr(@str nvarchar(100))
 returns bigint
as..]]></description><category></category></item><item><title><![CDATA[CentOS7 xmapp ftp带开放防火墙用户的服务的配置]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/52513806</link><guid>https://blog.youkuaiyun.com/helodd/article/details/52513806</guid><author>helodd</author><pubDate>Mon, 12 Sep 2016 15:34:36 +0800</pubDate><description><![CDATA[xmapp 已集成了ProFTPD服务器，要使用该FTP服务，需要做如下的配置


1、添加FTP用户
 # groupadd ftpusers #创建用户级ftpusers

输入命令：
# mkdir /www/ #创建目录www
# chmod -R 777 /www/ #设置权限，好像必须777
# useradd -d /www/ -g ftpusers -s /sbi]]></description><category></category></item><item><title><![CDATA[CentOS7配置多监听端口与多虚拟主机]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/52495754</link><guid>https://blog.youkuaiyun.com/helodd/article/details/52495754</guid><author>helodd</author><pubDate>Sat, 10 Sep 2016 16:48:13 +0800</pubDate><description><![CDATA[1、开打多监听端口

httpd.conf 文件
Listen 80
Listen 8888




     这样就打开了80 同8888端口。

2、配置 httpd-vhost.conf  文件加入虚拟主机


    ServerAdmin webmaster@test.com
    DocumentRoot /var/www/html80
    Ser]]></description><category></category></item><item><title><![CDATA[centos7 firewall打开端口]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/51103418</link><guid>https://blog.youkuaiyun.com/helodd/article/details/51103418</guid><author>helodd</author><pubDate>Sat, 09 Apr 2016 09:51:03 +0800</pubDate><description><![CDATA[CentOS升级到7之后，发现无法使用iptables控制Linuxs的端口，google之后发现Centos 7使用firewalld代替了原来的iptables。下面记录如何使用firewalld开放Linux端口：

开启端口

firewall-cmd --zone=public --add-port=80/tcp --permanent

命令含义：

--zone #作]]></description><category></category></item><item><title><![CDATA[网页常用Javascript--转]]></title><link>https://blog.youkuaiyun.com/helodd/article/details/3399675</link><guid>https://blog.youkuaiyun.com/helodd/article/details/3399675</guid><author>helodd</author><pubDate>Fri, 28 Nov 2008 09:27:00 +0800</pubDate><description><![CDATA[网页常用Javascript 1．让文字不停地滚动 　　＜MARQUEE＞滚动文字＜/MARQUEE＞ 2．记录并显示网页的最后修改时间 　　＜script language=Javascript＞ 　　document.write("最后更新时间: " + document.lastModified + "") 　　＜/script＞ 3．关闭当前窗口 　　＜a href="/"onClick=]]></description><category></category></item></channel></rss>