DROP TEMPORARY TABLE IF EXISTS count_transfer;
CREATE TEMPORARY TABLE IF NOT EXISTS table_name
SELECT DISTINCT s1.table_nameas table_name,0 as count_row,0 as count_row_t
FROM INFORMATION_SCHEMA.COLUMNS s1
ALTER TABLE `f_diagnosis_opd`
ADD INDEX `SITECODE, HOSPCODE, Date_Serv, DiagType` (`SITECODE`, `HOSPCODE`, `Date_Serv`, `DiagType`) USING BTREE ;