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

directory path for ssk ubuntu software download

http://203.157.165.99/program/

haguichi

sudo add-apt-repository -y ppa:webupd8team/haguichi
sudo apt update
sudo apt install -y haguichi