全选(高亮显示):按esc后,然后ggvG或者ggVG
全部复制:按esc后,然后ggyG
全部删除:按esc后,然后dG
解析:
gg:是让光标移到首行,在vim才有效,vi中无效
v : 是进入Visual(可视)模式
G :光标移到最后一行
选中内容以后就可以其他的操作了,比如:
d 删除选中内容
y 复制选中内容到0号寄存器
"+y 复制选中内容到+寄存器,也就是系统的剪贴板,供其他程序用
#!/bin/sh
yes|sudo yum install make
yes|sudo yum install gcc
wget https://url
tar xzf redis-6.0.8.tar.gz
ln -s redis-6.0.8 redis
cd redis
mkdir log
make
mv redis.conf redis.conf.bak
wget http://url
/home/..../redis/src/redis-server /home/redis/redis.conf
SQL
alter table tablename modify column int[是否允许为空]
PostGresSql
select user0.user_id as account_name,'Active'::text As account_status,array_to_string(array_agg(role2_.name),'|'::text) as entitlement_name,
CASE
WHEN user0_.last_login_time is NULL THEN '01-Jan-1970 00:00:00'::text
ELSE to_char(user0.last_login_time,'DD-MON-YYYY HH24:MI:SS:000'::text)
END as last_logon
GRANT CONNECT ON DATABASE shcemaname TO 'USER'
GRANT USAGE ON SCHEMA schemaName TO 'USER'
GRANT INSERT,SELECT,UPDATE,DELETE,TRUNCATE ON ALL TABLES IN SCHEMA schema_name to 'USER'
GRANT SELECT ,UPDATE ON ALL SEQUENCES IN SCHEMA TO 'USER'
GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA schema_name TO 'USER'
ALTER DEFAULT PRIVILEGES IN SCHEMA shema_name GRANT INSERT,SELECT,UPDATE,DELETE ON TABLES TO 'USER'
ALTER DEFAULT PRIVILEGES IN SCHEMA shema_name GRANT SELECT,UPDATE,DELETE ON SEQUENCES TO 'USER'
ALTER DEFAULT PRIVILEGES IN SCHEMA shema_name GRANT EXECUTE ON FUNCTIONS TO 'USER'