刪除Windows 遠端桌面紀錄

1. >cmd
2. >regedit
3. HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client\Default 

SQL --

How to know Table rows in db?
select o.name, rows
from sysindexes i join sysobjects o on o.id=i.id
where indid < 2 and type='U'
order by rows

PSM Certification

Java

Class.isAssignableFrom()

Excel 密技

1. 大量修改欄位
1.1 Ctrl+F 

Docker normal command

ref https://docs.docker.com/engine/reference/commandline/cli/

$docker version
to get docker information

$docker run -it hello-world
-it : keep standard in/out 
to run hello-world container

$docker images
to know what image install this docker server

$docker container rm 9fc415fede9f
to delete container_id 9fc415fede9f

$docker rmi image 2cb0d9787c4d
to delete image_id 2cb0d9787c4d

MySQL Command

安裝  mysql client
$sudo apt-get install mysql-client-5.7
' install

登入
$mysql -h 172.21.2.171 -u root -p
'mysql >
'check account  'root'@'%'

使用系統資料庫(切換schema)
mysql>use mysql ;

server 有多少帳號
mysql>select @@version;
mysql>select user,host  from mysql.user;

mysql>show databases;
'DB
mysql> use piwik;
mysql>show tables;


建立 user
mysql>create user 'matomouser'@'localhost' IDENTIFIED BY 'usermatomo';
'注意, 記得client重新連線

mysql> grant select on piwik.* to 'matomouser'@'%'; 'read

建立資料庫
mysql>create database cljdb default character set utf8 collate utf8_bin;
mysql> grant all on cljdb.* to 'clj'@'%' with grant option;

查看表格設計
mysql>describe first_table;

個人操作改密碼
mysql>set password for 'matomouser'@'localhost'='usermatomo'