01.DROP TABLE IF EXISTS `tbl_test`;
02.CREATE TABLE `tbl_test` (
03. `id` int(11) NOT NULL AUTO_INCREMENT,
04. `syndrome` varchar(50) DEFAULT NULL,
05. `school_name` varchar(50) DEFAULT NULL,
06. `class` varchar(20) DEFAULT NULL,
07. `room` varchar(10) DEFAULT NULL,
08. `created_at` datetime DEFAULT NULL,
09. `updated_at` datetime DEFAULT NULL,
10. PRIMARY KEY (`id`),
11. KEY `id` (`id`),
12. KEY `school_name` (`school_name`),
13. KEY `class` (`class`),
14. KEY `room` (`room`),
15. KEY `syndrome` (`syndrome`)
16.) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
17.
18.INSERT INTO `tbl_test` (`id`,`syndrome`,`school_name`,`class`,`room`,`created_at`,`updated_at`) VALUES
19. (1,'1,16','school7','อนุบาล2','4',NULL,NULL),
20. (2,'1,13,11,17','school7','อนุบาล1','1',NULL,NULL),
21. (3,'1,2,3,4,5','school7','อนุบาล1','1',NULL,NULL),
22. (4,'1,16','school7','อนุบาล2','4',NULL,NULL),
23. (5,'1,16','school7','อนุบาล2','4',NULL,NULL),
24. (6,NULL,'school7','อนุบาล2','1',NULL,NULL),
25. (7,'1,11,12','school7','อนุบาล2','1',NULL,NULL),
26. (8,'7,8,9','school6','เตรียมอนุบาล','2',NULL,NULL),
27. (9,NULL,'school6','เตรียมอนุบาล','2',NULL,NULL),
28. (10,'7,8,9','school6','เตรียมอนุบาล','2',NULL,NULL),
29. (11,'1,4,5,6','school3','ประถมศึกษาปีที่ 2','2',NULL,NULL),
30. (12,NULL,'school3','ประถมศึกษาปีที่ 2','2',NULL,NULL),
31. (13,'1,4,5,6','school3','ประถมศึกษาปีที่ 2','2',NULL,NULL);
