hdc person temporary full with grave

DROP TEMPORARY TABLE IF EXISTS `person`;
CREATE TEMPORARY TABLE `person`
SELECT
  `person`.`HOSPCODE` ,
  `person`.`CID` ,
  `person`.`PID` ,
  `person`.`HID` ,
  `person`.`PRENAME` ,
  `person`.`NAME` ,
  `person`.`LNAME` ,
  `person`.`HN` ,
  `person`.`SEX` ,
  `person`.`BIRTH` ,
  `person`.`MSTATUS` ,
  `person`.`OCCUPATION_OLD` ,
  `person`.`OCCUPATION_NEW` ,
  `person`.`RACE` ,
  `person`.`NATION` ,
  `person`.`RELIGION` ,
  `person`.`EDUCATION` ,
  `person`.`FSTATUS` ,
  `person`.`FATHER` ,
  `person`.`MOTHER` ,
  `person`.`COUPLE` ,
  `person`.`VSTATUS` ,
  `person`.`MOVEIN` ,
  `person`.`DISCHARGE` ,
  `person`.`DDISCHARGE` ,
  `person`.`ABOGROUP` ,
  `person`.`RHGROUP` ,
  `person`.`LABOR` ,
  `person`.`PASSPORT` ,
  `person`.`TYPEAREA` ,
  `person`.`D_UPDATE` ,
  `person`.`TELEPHONE` ,
  `person`.`MOBILE` ,
  `person`.`HDC_DATE`
WHERE
  `person`.`HOSPCODE` = '03301';
SELECT * FROM `person`;

hdc person temporary full

DROP TEMPORARY TABLE IF EXISTS person;
CREATE TEMPORARY TABLE person
SELECT
  person.HOSPCODE ,
  person.CID ,
  person.PID ,
  person.HID ,
  person.PRENAME ,
  person.NAME ,
  person.LNAME ,
  person.HN ,
  person.SEX ,
  person.BIRTH ,
  person.MSTATUS ,
  person.OCCUPATION_OLD ,
  person.OCCUPATION_NEW ,
  person.RACE ,
  person.NATION ,
  person.RELIGION ,
  person.EDUCATION ,
  person.FSTATUS ,
  person.FATHER ,
  person.MOTHER ,
  person.COUPLE ,
  person.VSTATUS ,
  person.MOVEIN ,
  person.DISCHARGE ,
  person.DDISCHARGE ,
  person.ABOGROUP ,
  person.RHGROUP ,
  person.LABOR ,
  person.PASSPORT ,
  person.TYPEAREA ,
  person.D_UPDATE ,
  person.TELEPHONE ,
  person.MOBILE ,
  person.HDC_DATE
WHERE
  person.HOSPCODE = '03301';
SELECT * FROM person;

hdc person temporary

DROP TEMPORARY TABLE IF EXISTS person;
CREATE TEMPORARY TABLE person
SELECT
  HOSPCODE ,
  CID ,
  PID ,
  HID ,
  PRENAME ,
  NAME ,
  LNAME ,
  HN ,
  SEX ,
  BIRTH ,
  MSTATUS ,
  OCCUPATION_OLD ,
  OCCUPATION_NEW ,
  RACE ,
  NATION ,
  RELIGION ,
  EDUCATION ,
  FSTATUS ,
  FATHER ,
  MOTHER ,
  COUPLE ,
  VSTATUS ,
  MOVEIN ,
  DISCHARGE ,
  DDISCHARGE ,
  ABOGROUP ,
  RHGROUP ,
  LABOR ,
  PASSPORT ,
  TYPEAREA ,
  D_UPDATE ,
  TELEPHONE ,
  MOBILE ,
  HDC_DATE
FROM person
WHERE
  HOSPCODE = '03301';
SELECT * FROM person;

wqe

http://javseen.com/starring/minami-aizawa/

Last crontab

# /etc/crontab: system-wide crontab
# Unlike any other crontab you don't have to run the `crontab'
# command to install the new version when you edit this file
# and files in /etc/cron.d. These files also have username fields,
# that none of the other crontabs do.

SHELL=/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin

# m h dom mon dow user command
17 * * * * root    cd / && run-parts --report /etc/cron.hourly
25 6 * * * root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily )
47 6 * * 7 root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.weekly )
52 6 1 * * root test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.monthly )
55 12,17,20,23 * * 0-6 root /var/jhcis/mysql-backup-jhcisdb.sh >/dev/null 2>&1
0 0-23 * * 0-6 root sh /var/jepidem/runjepidem.sh >/dev/null 2>&1
0 0-23 * * 0-6 root sh /var/jxp18/runjxp18.sh >/dev/null 2>&1
0 0-22 * * 0-6 root sh /var/jautoup/runjauto.sh >/dev/null 2>&1
*/5 * * * * root sh /var/jhcis/create-pdf.sh /dev/null 2>&1
#end

lastest jhcis backup

# !/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 "-31 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

mysql query script

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