android:See your best photos & videos using highlights

See your best photos & videos using highlights

แก้ปัญหา gnome ubuntu

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install --reinstall gnome-session
startx

mysql-5.0.51b.tar.gz

https://downloads.mariadb.com/archives/mysql-5.0/mysql-5.0.51b.tar.gz

sudo /etc/init.d/mysql stop

sudo /opt/lampp/lampp startmysql

"tar -zxvf mysql-5.0.51b.tar.gz"

http://repository.timesys.com/buildsources/m/mysql/mysql-5.0.51b/mysql-5.0.51b.tar.gz

bat restore

cd\
cd C:\Program Files\JHCIS\MySQL\bin
mysql --default-character-set=utf8 -uroot -p123456 -P3333 -f jhcisdb < "C:\\sqlBackupFileName.sql"
pause

create_person_FEDERATED ( remote sever table mysql )

DROP TABLE IF EXISTS `person_FEDERATED`;
CREATE TABLE `person_FEDERATED` (
  `pcucodeperson` char(5) NOT NULL default '',
  `pid` int(11) NOT NULL,
  `hcode` int(11) NOT NULL,
  `prename` varchar(20) default NULL,
  `fname` varchar(25) NOT NULL,
  `lname` varchar(35) default NULL,
  `birth` date default NULL,
  `sex` varchar(1) NOT NULL,
  `idcard` varchar(13) default NULL,
  `bloodgroup` varchar(2) default NULL,
  `bloodrh` varchar(1) default NULL,
  `allergic` varchar(100) default NULL,
  `marystatus` varchar(1) default NULL,
  `educate` char(2) default NULL,
  `occupa` char(4) default NULL,
  `nation` varchar(3) default NULL,
  `origin` varchar(3) default NULL,
  `intercode` varchar(2) default NULL,
  `religion` char(2) default NULL,
  `familyno` tinyint(4) default NULL,
  `familyposition` varchar(1) default NULL,
  `income` double default NULL,
  `typelive` varchar(1) default NULL,
  `datein` date default NULL,
  `dischargetype` varchar(1) default NULL,
  `dischargedate` date default NULL,
  `father` varchar(257) default NULL,
  `fatherid` varchar(13) default NULL,
  `mother` varchar(257) default NULL,
  `motherid` varchar(13) default NULL,
  `mate` varchar(257) default NULL,
  `mateid` varchar(13) default NULL,
  `privatedoc` varchar(255) default NULL,
  `rightcode` char(4) default NULL,
  `rightno` varchar(18) default NULL,
  `hosmain` char(9) default NULL,
  `hossub` char(9) default NULL,
  `dateregis` date default NULL,
  `datestart` date default NULL,
  `dateexpire` date default NULL,
  `officework` char(254) default NULL,
  `hnomoi` varchar(75) default NULL,
  `roadmoi` varchar(50) default NULL,
  `mumoi` char(2) default NULL,
  `subdistcodemoi` char(2) default NULL,
  `distcodemoi` char(2) default NULL,
  `provcodemoi` char(2) default NULL,
  `postcodemoi` char(5) default NULL,
  `telephoneperson` varchar(35) default NULL,
  `hcodeoldin` int(11) default NULL,
  `dateupdate` datetime default NULL,
  `flag18fileexpo` varchar(1) default NULL,
  `messengername` varchar(255) default NULL,
  `messengeraddr` varchar(255) default NULL,
  `messengertel` varchar(55) default NULL,
  `patientrelate` varchar(255) default NULL,
  `mommilk` int(11) default NULL,
  `persondisease` varchar(350) default NULL,
  `flagoffline` char(1) default NULL,
  `nickname` varchar(25) default NULL,
  `prenameeng` varchar(25) default NULL,
  `fnameeng` varchar(35) default NULL,
  `lnameeng` varchar(45) default NULL,
  `person_house_position_id_from_hosxp` int(11) default NULL,
  `Address from antidrug` text,
  `Update Date antidrug` date default NULL,
  `passpotnumber` varchar(37) default NULL,
  `workpermitnumber` varchar(37) default NULL,
  `hidmoi11` char(11) default NULL,
  `housetype` char(1) default NULL,
  `roomno` varchar(10) default NULL,
  `condo` varchar(75) default NULL,
  `soisub` varchar(255) default NULL,
  `soimain` varchar(255) default NULL,
  `dateupdateaddressout` datetime default NULL,
  `candobedhomesocial` char(1) default NULL,
  `beastprojectout` char(1) default NULL,
  PRIMARY KEY  (`pcucodeperson`,`pid`),
  UNIQUE KEY `id_Card` (`pcucodeperson`,`idcard`),
  UNIQUE KEY `RN` (`pcucodeperson`,`rightno`),
  KEY `house_pers` (`pcucodeperson`,`hcode`),
  KEY `per_educate` (`educate`),
  KEY `per_nation` (`nation`),
  KEY `per_race` (`origin`),
  KEY `per_occupa` (`occupa`),
  KEY `per_relig` (`religion`),
  KEY `per_right` (`rightcode`),
  KEY `per_status` (`marystatus`),
  KEY `per_hosmain` (`hosmain`),
  KEY `chos_pshs1` (`hossub`),
  CONSTRAINT `person_ibfk_1` FOREIGN KEY (`hossub`) REFERENCES `chospital` (`hoscode`) ON UPDATE CASCADE,
  CONSTRAINT `person_ibfk_10` FOREIGN KEY (`occupa`) REFERENCES `coccupa` (`occupacode`) ON UPDATE CASCADE,
  CONSTRAINT `person_ibfk_2` FOREIGN KEY (`origin`) REFERENCES `cnation` (`nationcode`) ON UPDATE CASCADE,
  CONSTRAINT `person_ibfk_3` FOREIGN KEY (`religion`) REFERENCES `creligion` (`religioncode`) ON UPDATE CASCADE,
  CONSTRAINT `person_ibfk_4` FOREIGN KEY (`rightcode`) REFERENCES `cright` (`rightcode`) ON UPDATE CASCADE,
  CONSTRAINT `person_ibfk_5` FOREIGN KEY (`marystatus`) REFERENCES `cstatus` (`statuscode`) ON UPDATE CASCADE,
  CONSTRAINT `person_ibfk_6` FOREIGN KEY (`pcucodeperson`, `hcode`) REFERENCES `house` (`pcucode`, `hcode`) ON UPDATE CASCADE,
  CONSTRAINT `person_ibfk_7` FOREIGN KEY (`educate`) REFERENCES `ceducation` (`educationcode`) ON UPDATE CASCADE,
  CONSTRAINT `person_ibfk_8` FOREIGN KEY (`hosmain`) REFERENCES `chospital` (`hoscode`) ON UPDATE CASCADE,
  CONSTRAINT `person_ibfk_9` FOREIGN KEY (`nation`) REFERENCES `cnation` (`nationcode`) ON UPDATE CASCADE
)
ENGINE=FEDERATED
DEFAULT CHARSET=utf8
CONNECTION='mysql://root:123456@127.0.0.1:3333/jhcisdb/person';

ดูผู้ป่วย DM

'ต้องมี view ชื่อ cid จากข้อที่แล้ว
SELECT
substr(house.villcode,7,2) as moo,
house.hno,
person.pid,
person.idcard,
ctitle.titlename,
person.fname,
person.lname,
cid.`อายุ`
FROM
person
LEFT JOIN cid ON person.idcard = cid.cid2
INNER JOIN house ON person.pcucodeperson = house.pcucode AND person.hcode = house.hcode
LEFT JOIN ctitle ON ctitle.titlecode = person.prename
WHERE
cid.cid2 IS NOT NULL AND
LENGTH(cid.cid2) = 13 AND
cid.`ตำบล` = 'หนองหัวช้าง' AND
cid.`หมู่` IN ('1','2','5','8','9','12')
ORDER BY
house.villcode ASC

ตัด - ออกจาก cid (view ชื่อ cid)

select `dm_kr`.`CID` AS `CID`,concat(substr(`dm_kr`.`CID`,1,1),substr(`dm_kr`.`CID`,3,4),substr(`dm_kr`.`CID`,8,5),substr(`dm_kr`.`CID`,14,2),substr(`dm_kr`.`CID`,17,1)) AS `cid2`,`dm_kr`.`ลงทะเบียน` AS `ลงทะเบียน`,`dm_kr`.`HN` AS `HN`,`dm_kr`.`clinicno` AS `clinicno`,`dm_kr`.`fullname` AS `fullname`,`dm_kr`.`ptdob` AS `ptdob`,`dm_kr`.`อายุ` AS `อายุ`,`dm_kr`.`oldnew` AS `oldnew`,`dm_kr`.`cliname` AS `cliname`,`dm_kr`.`บ้านเลขที่` AS `บ้านเลขที่`,`dm_kr`.`หมู่` AS `หมู่`,`dm_kr`.`ตำบล` AS `ตำบล`,`dm_kr`.`อำเภอ` AS `อำเภอ`,`dm_kr`.`จังหวัด` AS `จังหวัด`,`dm_kr`.`typearea` AS `typearea`,`dm_kr`.`icd10` AS `icd10`,`dm_kr`.`หมายเหตุ` AS `หมายเหตุ` from `dm_kr`