01.CREATE TABLE `cus_A` ( `Id` int(11) NOT NULL auto_increment, `Company` varchar(50) NOT NULL, `Code` varchar(6) NOT NULL, `Name_save` varchar(50) NOT NULL, `Name_pro` varchar(50) NOT NULL, `Piece` int(11) NOT NULL, `Status` varchar(10) NOT NULL, `Date` date NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ; -- -- dump ตาราง `cus` -- INSERT INTO `cus` VALUES (1, 'A', '600001', 'MMM', 'box 30*30', 20, '2', '2018-01-01'); INSERT INTO `cus` VALUES (2, 'B', '600002', 'MMM', 'box 30*30', 10, '3', '2018-01-01'); INSERT INTO `cus` VALUES (3, 'C', '600003', 'PPP', 'box 60*60', 30, '3', '2018-01-01'); INSERT INTO `cus` VALUES (4, 'D', '600004', 'PPP', 'box 60*60', 20, '4', '2018-01-02'); INSERT INTO `cus` VALUES (5, 'E', '600005', 'WWW', 'box 20*20', 15, '4', '2018
02.
03.
04.
05.CREATE TABLE `cus_B` ( `Id` int(11) NOT NULL auto_increment, `Company` varchar(50) NOT NULL, `Code` varchar(6) NOT NULL, `Name_save` varchar(50) NOT NULL, `Name_pro` varchar(50) NOT NULL, `Piece` int(11) NOT NULL, `Status` varchar(10) NOT NULL, `Date` date NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ; -- -- dump ตาราง `cus` -- INSERT INTO `cus` VALUES (1, 'A', '600001', 'MMM', 'box 30*30', 20, '2', '2018-01-01'); INSERT INTO `cus` VALUES (2, 'B', '600002', 'MMM', 'box 30*30', 10, '3', '2018-01-01'); INSERT INTO `cus` VALUES (3, 'C', '600003', 'PPP', 'box 60*60', 30, '3', '2018-01-01'); INSERT INTO `cus` VALUES (4, 'D', '600004', 'PPP', 'box 60*60', 20, '4', '2018-01-02'); INSERT INTO `cus` VALUES (5, 'E', '600005', 'WWW', 'box 20*20', 15, '4', '2018
06.
07.
08.CREATE TABLE `cus_C` ( `Id` int(11) NOT NULL auto_increment, `Company` varchar(50) NOT NULL, `Code` varchar(6) NOT NULL, `Name_save` varchar(50) NOT NULL, `Name_pro` varchar(50) NOT NULL, `Piece` int(11) NOT NULL, `Status` varchar(10) NOT NULL, `Date` date NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ; -- -- dump ตาราง `cus` -- INSERT INTO `cus` VALUES (1, 'A', '600001', 'MMM', 'box 30*30', 20, '2', '2018-01-01'); INSERT INTO `cus` VALUES (2, 'B', '600002', 'MMM', 'box 30*30', 10, '3', '2018-01-01'); INSERT INTO `cus` VALUES (3, 'C', '600003', 'PPP', 'box 60*60', 30, '3', '2018-01-01'); INSERT INTO `cus` VALUES (4, 'D', '600004', 'PPP', 'box 60*60', 20, '4', '2018-01-02'); INSERT INTO `cus` VALUES (5, 'E', '600005', 'WWW', 'box 20*20', 15, '4', '2018
09.
10.
11.CREATE TABLE `cus_D` ( `Id` int(11) NOT NULL auto_increment, `Company` varchar(50) NOT NULL, `Code` varchar(6) NOT NULL, `Name_save` varchar(50) NOT NULL, `Name_pro` varchar(50) NOT NULL, `Piece` int(11) NOT NULL, `Status` varchar(10) NOT NULL, `Date` date NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ; -- -- dump ตาราง `cus` -- INSERT INTO `cus` VALUES (1, 'A', '600001', 'MMM', 'box 30*30', 20, '2', '2018-01-01'); INSERT INTO `cus` VALUES (2, 'B', '600002', 'MMM', 'box 30*30', 10, '3', '2018-01-01'); INSERT INTO `cus` VALUES (3, 'C', '600003', 'PPP', 'box 60*60', 30, '3', '2018-01-01'); INSERT INTO `cus` VALUES (4, 'D', '600004', 'PPP', 'box 60*60', 20, '4', '2018-01-02'); INSERT INTO `cus` VALUES (5, 'E', '600005', 'WWW', 'box 20*20', 15, '4', '2018
