CREATE TABLE `emp_doc_attendance` (
  `Date` date NOT NULL,
  `HMSD001` char(1) NOT NULL DEFAULT 'P',
  `HMSD002` char(1) NOT NULL DEFAULT 'P',
  `HMSD003` char(1) NOT NULL DEFAULT 'P',
  `HMSD004` char(1) NOT NULL DEFAULT 'p',
  `HMSD005` char(1) NOT NULL DEFAULT 'p',
  `HMSD006` char(1) NOT NULL DEFAULT 'p',
  `HMSD007` char(1) NOT NULL DEFAULT 'p',
  `HMSD008` char(1) NOT NULL DEFAULT 'p',
  `HMSD009` char(1) NOT NULL DEFAULT 'p',
  `HMSD010` char(1) NOT NULL DEFAULT 'p',
  `HMSD011` char(1) NOT NULL DEFAULT 'p',
  `HMSD012` char(1) NOT NULL DEFAULT 'p',
  `HMSD013` char(1) NOT NULL DEFAULT 'p',
  `HMSD014` char(1) NOT NULL DEFAULT 'p',
  `HMSD015` char(1) NOT NULL DEFAULT 'p',
  `HMSD016` char(1) NOT NULL DEFAULT 'p',
  `HMSD017` char(1) NOT NULL DEFAULT 'p',
  `HMSD018` char(1) NOT NULL DEFAULT 'p',
  `HMSD019` char(1) NOT NULL DEFAULT 'p',
  `HMSD020` char(1) NOT NULL DEFAULT 'p',
  `HMSD021` char(1) NOT NULL DEFAULT 'p',
  `HMSD022` char(1) NOT NULL DEFAULT 'p',
  `HMSD024` char(1) NOT NULL DEFAULT 'P',
  `HMSD025` char(1) NOT NULL DEFAULT 'P',
  `HMSD026` char(1) NOT NULL DEFAULT 'P',
  `HMSD027` char(1) NOT NULL DEFAULT 'P',
  `HMSD028` char(1) NOT NULL DEFAULT 'P',
  `HMSD029` char(1) NOT NULL DEFAULT 'P',
  `HMSD030` char(1) NOT NULL DEFAULT 'P',
  `HMSD031` char(1) NOT NULL DEFAULT 'P',
  `HMSD032` char(1) NOT NULL DEFAULT 'P',
  `HMSD033` char(1) NOT NULL DEFAULT 'P',
  `HMSD034` char(1) NOT NULL DEFAULT 'P',
  `HMSD035` char(1) NOT NULL DEFAULT 'P',
  `HMSD036` char(1) NOT NULL DEFAULT 'p',
  `HMSD037` char(1) NOT NULL DEFAULT 'p',
  `HMSD038` char(1) NOT NULL DEFAULT 'p',
  `HMSD039` char(1) NOT NULL DEFAULT 'p',
  `HMSD040` char(1) NOT NULL DEFAULT 'p',
  `HMSD041` char(1) NOT NULL DEFAULT 'p',
  `HMSD042` char(1) NOT NULL DEFAULT 'p',
  `HMSD043` char(1) NOT NULL DEFAULT 'p',
  `HMSD044` char(1) NOT NULL DEFAULT 'p',
  `HMSD045` char(1) NOT NULL DEFAULT 'p',
  `HMSD046` char(1) NOT NULL DEFAULT 'p',
  `HMSD047` char(1) NOT NULL DEFAULT 'p',
  `HMSD048` char(1) NOT NULL DEFAULT 'p',
  `HMSD049` char(1) NOT NULL DEFAULT 'p',
  `HMSD050` char(1) NOT NULL DEFAULT 'p',
  PRIMARY KEY (`Date`),
  UNIQUE KEY `Date_UNIQUE` (`Date`),
  CONSTRAINT `fk_Doc_Attendance_1` FOREIGN KEY (`Date`) REFERENCES `calendar` (`dt`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
![enter image description here][1]

coulumn_name  month       COUNT FOR (P PRESENT IN IT)
HMS001        jAN-2014     10
HMS002        FEB-2014     20
HMS003        -
HMS004       -
-              DEC-2014
-

HMS001        jAN-2015     10
HMS002        FEB-2015     20
HMS003        -
HMS004       -
-              DEC-2015
-
-