โครงการตามแนวทางพระราชดำริด้านสาธารณสุข 2561

https://drive.google.com/drive/folders/1emxT_gMSEOhvDPxmyzS2B2wWa9dyWkPO?usp=sharing

LOGITECH BRIO 4k usb webcam

https://www.jib.co.th/web/index.php/product/readProduct/27700/510/VIDEO-WEBCAM--%E0%B9%80%E0%B8%A7%E0%B9%87%E0%B8%9A%E0%B9%81%E0%B8%84%E0%B8%A1--LOGITECH-GAMING-BRIO-4K-HD-RIGHTLIGHT

ยังคง err

Query:
/*!50003 SET character_set_client  = utf8mb4 */

Error occured at:2018-02-25 07:31:55
Line no.:18041
Error Code: 1115 - Unknown character set: 'utf8mb4'

tmp

init_connect = ‘set collation_connection = utf8_general_ci’
init_connect = ‘set names utf8’

ได้ใหม

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