 |
|
รบกวนขอตัวอย่างโค้ดหน่อยค่ะ
Code (PHP)
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
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
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
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
Tag : PHP, MySQL
|
ประวัติการแก้ไข
2018-01-20 14:29:38
|
 |
 |
 |
 |
| Date :
2018-01-20 14:26:41 |
By :
panthipa |
View :
740 |
Reply :
3 |
|
 |
 |
 |
 |
|
|
|
|
 |
