SELECT 'hoscode','schoolcode','schoolname','depend','maxclass','dateupdate' union all
(SELECT v.pcucode as 'hoscode',CONCAT(v.villcode,v.schoolno) as 'schoolcode',v.schoolname,v.depend,v.maxclass,v.dateupdate
FROM villageschool v
INTO OUTFILE 'C:/JHCIS_export/school.txt'
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\r\n');