· 8 years ago · Jul 04, 2018, 03:24 PM
1SET FOREIGN_KEY_CHECKS=0;
2
3-- ----------------------------
4-- Table structure for `fruits`
5-- ----------------------------
6DROP TABLE IF EXISTS `fruits`;
7CREATE TABLE `fruits` (
8 `id` int(4) NOT NULL AUTO_INCREMENT,
9 `fruit_types` varchar(100) DEFAULT NULL,
10 PRIMARY KEY (`id`)
11) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
12
13-- ----------------------------
14-- Records of fruits
15-- ----------------------------
16INSERT INTO `fruits` VALUES ('1', 'apples,pears');
17INSERT INTO `fruits` VALUES ('2', 'apples,oranges');
18INSERT INTO `fruits` VALUES ('3', 'oranges,pears');
19INSERT INTO `fruits` VALUES ('4', 'oranges,bananas,pears');
20INSERT INTO `fruits` VALUES ('5', 'apples,bananas');