kk Blog —— 通用基础

insert into tablename (字段名1,字段名2,...,字段名3) select 字段名1,字段名2,...,字段名3 from tablename where id=...

insert into tb (a, b, c)  select  '20211015', b, c from tb where id=123;

setenforce 0

vim /etc/sysconfig/selinux
SELINUX=enforcing       =>      SELINUX=disabled

port_nat_t = 4501

# Include config snippets
include conf.d/*.conf

connections {
	# cp www.abcxyzkk.xyz_apache/root_bundle.crt /etc/strongswan/swanctl/x509ca/
	# cp www.abcxyzkk.xyz_apache/www.abcxyzkk.xyz.crt /etc/strongswan/swanctl/x509/
	# cp www.abcxyzkk.xyz_apache/www.abcxyzkk.xyz.key /etc/strongswan/swanctl/private/
	# EAP android 客户端 https://download.strongswan.org/Android/
	# EAP android 客户端 https://raw.githubusercontent.com/abcdxyzk/abcdxyzk.github.io_files/master/tools/vpn/strongSwan-2.3.3.apk
	# EAP 服务端转发上网 iptables -t nat -A POSTROUTING -s 100.64.0.0/24 -o eth0 -j MASQUERADE
	# echo 1 > /proc/sys/net/ipv4/ip_forward
        testEAP {
                version = 2
                proposals = default
                local_addrs = 192.168.100.178
                pools = pool1
                rekey_time = 24h

                local {
                        certs = www.npcable.cn.crt
                        id = www.npcable.cn
                }
                remote {
                        auth = eap-mschapv2
                        id = %any
                }
                children {
                        testEAP_child {
                                # local_ts = 0.0.0.0/0
                                local_ts = 192.168.100.0/24
                                #remote_ts = 100.64.0.0/24
                                esp_proposals = default

                                rekey_time = 24h
                        }
                }
        }
}

secrets {
        private-www {
                file = www.npcable.cn.key
        }
        eap-user {
                id = abc
                secret = abc123
        }
        eap-user1 {
                id = abc1
                secret = abc123
        }
}

pools {
	pool1 {
		addrs = 100.64.0.0/24
	}
}

service strongswan restart

swanctl --load-all
swanctl --list-sas

<?php
$m1 = memory_get_usage();

$arr = array(
);

$m2 = memory_get_usage();

$arr2 = array(
    'testa'=>'hello world1',
    'testb'=>'hello world2',
);

$m3 = memory_get_usage();

echo $m1.PHP_EOL;
echo $m2.PHP_EOL;
echo 'usage: '.($m2-$m1), PHP_EOL;
echo $m3.PHP_EOL;
echo 'usage: '.($m3-$m2), PHP_EOL;

92216
92656
usage: 440
93432
usage: 776