01.CREATE TABLE IF NOT EXISTS `orders` (
02. `OrderId` int(5) NOT NULL,
03. `ProductID` varchar(100) COLLATE utf8_unicode_ci NOT NULL
04.) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
05.
06.--
07.-- Dumping data for table `orders`
08.--
09.
10.INSERT INTO `orders` (`OrderId`, `ProductID`) VALUES
11.(1, '1,2,4'),
12.(2, '1,3,4'),
13.(3, '1,2,3,4'),
14.(4, '2,4'),
15.(5, '1,4');
16.
17.ALTER TABLE `orders`
18. ADD PRIMARY KEY (`OrderId`);
19.
20.CREATE TABLE IF NOT EXISTS `product` (
21. `ProductID` int(4) NOT NULL,
22. `ProductName` varchar(100) NOT NULL,
23. `Price` double NOT NULL,
24. `Picture` varchar(100) NOT NULL
25.) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
26.
27.--
28.-- Dumping data for table `product`
29.--
30.
31.INSERT INTO `product` (`ProductID`, `ProductName`, `Price`, `Picture`) VALUES
32.(1, 'Product 1', 100, '1.gif'),
33.(2, 'Product 2', 200, '2.gif'),
34.(3, 'Product 3', 300, '3.gif'),
35.(4, 'Product 4', 400, '4.gif');
36.
37.ALTER TABLE `product`
38. ADD PRIMARY KEY (`ProductID`);
39.
40.
41.
42.
43.
44.
45.
46.$id=3;
47.
48.SELECT * FROM orders WHERE ProductID=$id;
49.
50.
51.
52.SELECT * FROM orders WHERE ProductID IN($id);
53.
54.
55.
