lanxingmo的专栏

Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.行的长度不能超过65535，即列的大小总和除了BLOBs longtext类型，总大小不能超过65535，修改列的大小，并将部分列修改为longtext...

Failed to list *v1.Namespace: Get https://10.96.0.1:443/api/v1/namespaces?limit=500&resourceVersion=0: dial tcp 10.96.0.1:443: connect: no route to host路由问题：iptables -L解决：先缩减kubectl scale --replicas=0 deploy/coredns -n kube-system再增加kub...

~/redis-cli -h 127.0.0.1 -a passwd --raw keys "IM_GROUP_MEMBERS_*" | xargs ~/redis-cli -h 127.0.0.1 -a passwd del

mysql> select id from topic group by update_time having count(update_time) > 1;ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'imdb.topic.id' which is not functionally dependent on co...

6位小数：CREATE TABLE `topic2`(`update_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),`detail_location` varchar(1024) DEFAULT '' COMMENT '详细地址');mysql> insert into topic2(detail_location)values('dddd');Query OK

docker images |grep xxx | awk -F' ' '{print $1}' | xargs docker rmi

挂载参数位置问题如修改挂载参数顺序即可docker run -it -v /hostpath:/work/conf --name test8 test

hostname xxxvi /etc/hostnamexxxx

git checkoutdev-usergit push -f origin dev-user

导出表结构及数据mysqldump -uroot -hxxx.com -pxxx dbname tablename > tablename.txt仅导出表结构加 -dmysqldump -uroot -hxxx.com -pxxx -d dbname tablename > tablename.txt备份所有数据库mysqldump -u root -p --all-databases > database_dump.txt导出库mysqldump -u...