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`;
