ได้ใหม

RETURNS varchar(255) CHARSET utf8 COLLATE utf8_general_ci

mysql-backup-jhcisdb.sh 256102221921

# !/bin/sh

sudo mysqldump --skip-comments --default-character-set=utf8 --routines --lock-tables=false --compatible=no_key_options -u root -p123456 jhcisdb > /home/jhcis/backupjhcis/jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/backupjhcis/jhcisdb-03301.$(date -d "-7 day" "+%Y-%m-%d").sql

sudo mysqldump --skip-comments --default-character-set=utf8 --routines --lock-tables=false --compatible=no_key_options -u root -p123456 jhcisdb > /home/jhcis/Dropbox/backupjhcis/jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/Dropbox/backupjhcis/jhcisdb-03301.$(date -d "-7 day" "+%Y-%m-%d").sql

sudo mysqldump --skip-comments --default-character-set=utf8 --routines --compatible=no_key_options  -u root -p123456 jepidem > /home/jhcis/backupjhcis/jepidem-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/backupjhcis/jepidem-03301.$(date -d "-7 day" "+%Y-%m-%d").sql

sudo mysqldump --skip-comments --routines --allow-keywords --add-drop-table --compatible=no_key_options,no_table_options --no-set-names --lock-tables --skip-set-charset --skip-disable-keys --skip-add-locks -u root -p123456 jepidem > /home/jhcis/Dropbox/backupjhcis/jepidem-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
sudo rm -f /home/jhcis/Dropbox/backupjhcis/jepidem-03301.$(date -d "-7 day" "+%Y-%m-%d").sql

mySQL ตัดเครื่องหมาย "-" ออกจากเลขประจำตัวประชาชน

update `dm-hba1c` set `dm-hba1c`.cardid = CONCAT(Left(`dm-hba1c`.cardid,1),Mid(`dm-hba1c`.cardid,3,4),Mid(`dm-hba1c`.cardid,8,5),Mid(`dm-hba1c`.cardid,14,2),Right(`dm-hba1c`.cardid,1))

cascap

ICD 10 การคัดกรองมะเร็งตับ Z12.8

หัตถการ                 9270700

Troken

y6s383bp3467j5x5

พิกัด

15.025714,104.252374

การคำนวณเวลาราชการ

ปี =DATEDIF(DATE(YEAR(D19)-543,MONTH(D19),DAY(D19)),DATE(YEAR(D20)-543,MONTH(D20),DAY(D20)),"y")
เดือน =DATEDIF(DATE(YEAR(D19)-543,MONTH(D19),DAY(D19)),DATE(YEAR(D20)-543,MONTH(D20),DAY(D20)),"ym")
ปี =DATEDIF(DATE(YEAR(D19)-543,MONTH(D19),DAY(D19)),DATE(YEAR(D20)-543,MONTH(D20),DAY(D20)),"md")