1.Alt +P 进入sftp会话
2.pwd显示linux目录 lpwd显示windows目录
3.lcd切换windows目录 cd切换linux目录
4.put上传
5.get下载
6.help帮助
create or replace view alltest as
select
a.host as host,
a.ip as ip,
a.sno as sno1,
b.sno as sno2,
b.content as content,
concat(substring(b.content,8, 2),substring(b.content,12, 2)) as new
from test.test1 a
left join test.test2 b on trim(a.sno)=trim(b.sno)