ยังคง 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

Troken

y6s383bp3467j5x5