MasOS SSH UTF8 Error Tips
There is LC_CTYPE error while connect to VM via ssh.
YourMacBook-Pro ~ % ssh root@127.0.0.1 -p2223
root@127.0.0.1's password:
Last login: Wed Mar 2 11:00:35 2022 from gateway
-bash: warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No such file or directory
[root@centos7 ~]#
Edit /etc/ssh/ssh_config and comment out SendEnv LANG LC_*.
YourMacBook-Pro:~ you$ sudo vi /etc/ssh/ssh_config
## SendEnv LANG LC_*
warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No such file or directory
Have a good work&life! 2022/03 via LinHong
MySQL Study 002 - ROWNUM Tips
There is NOT row_num function in MySQL.
How to achieve this function in MySQL?
MySQL Study 001 - Install Tips
Linux perl error in bash Tips
perl: warning: Setting locale failed.
Oracle Basic SQL 014 Study Tips
Sub-queries in select can be converted to left join (use_hj/use_nl)
Tips: The execution plan has the OUTER keyword
标量子查询可以转left join外连接（use_hj/use_nl)
Tips:
OUTER关键字Oracle Basic SQL 013 Study Tips
Remove characters from a string
Split strings and numbers
Oracle Basic SQL 012 Study Tips
Generate a continuous number
Query iterate over the string one by one
Oracle Basic SQL 011 Study Tips
Delete the same contents.
Oracle Basic SQL 010 Study Tips
Multi-table association update, Please use merge into or update via VIEW.
MERGE INTO Tips.
merge into xxx
using ()
on ()
when matched then
update ...
when not matched then
insert ... values ...
Oracle Basic SQL 009 Study Tips
Oracle Basic SQL 008 Study Tips
INSERT default value.
Use view to protect default value.
Oracle Basic SQL 007 Study Tips
List department name with only department name and no employees in it.
eg. department_id: 170 (Manufacturing) there is NOT employees in this department.