欢迎投稿

今日深度:

MariaDB(mysql)排序诡异问题,mariadbmysql排序

MariaDB(mysql)排序诡异问题,mariadbmysql排序


这是一个比较诡异的问题

这样的一句SQL,在不同的mysql版本中,返回的结果是不同的并且5.5.37-MariaDB这个版本数据库,每次的结果都会随机变化。其他版本数据不会不断变化。


前提条件是:

1、有变量(如$time=time())或这类函数 p.`start_date` < unix_timestamp() and p.`end_date` > unix_timestamp()

2、关联了这个表 LEFT JOIN m_productgroup_product AS pgp ON po.`id`   = pgp.`product_option_id`

(暂时发现是这2种情况共有才存在这个问题)

解决方法:

ORDER BY p.id ASC
后面增加po.id排序

ORDER BY p.id ASC , po.id ASC


$sql = "
SELECT po.`id`, p.`id` AS product_id 
FROM  m_product_option AS po 
	LEFT JOIN m_product AS p ON po.`product_id`       = p.`id`  
	LEFT JOIN m_productgroup_product AS pgp ON po.`id`   = pgp.`product_option_id`
WHERE 
	p.`start_date` < unix_timestamp() and p.`end_date` > unix_timestamp() 
ORDER BY p.id ASC 
";


返回结果:

mysql5.1 【值恒定】

1092-139
1107-139
1122-139
1093-139

mysql5.5.8【值恒定】

1082-139
1121-139
1104-139
1083-139

5.5.37-MariaDB【值变化】



$db_hostname    = 'localhost';
$db_username    = 'test1';
$db_password    = 'test1';
$db_database    = 'test';

$time = time();//unix_timestamp()
$sql = "
SELECT po.`id`, p.`id` AS product_id 
FROM  m_product_option AS po 
	LEFT JOIN m_product AS p ON po.`product_id`       = p.`id`  
	LEFT JOIN m_productgroup_product AS pgp ON po.`id`   = pgp.`product_option_id`
WHERE 
	p.`start_date` < unix_timestamp() and p.`end_date` > unix_timestamp() 
ORDER BY p.id ASC 
";


echo $sql.'<br>';
$link = mysql_connect($db_hostname, $db_username, $db_password);
mysql_select_db($db_database, $link);
$resource	= mysql_query($sql, $link);
while ($result = mysql_fetch_assoc($resource)) {
	echo $result['id'].'-'.$result['product_id'].'<br>';
}



sql文件:

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50508
Source Host           : localhost:3306
Source Database       : test

Target Server Type    : MYSQL
Target Server Version : 50508
File Encoding         : 65001

Date: 2015-09-24 10:29:54
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `m_product`
-- ----------------------------
DROP TABLE IF EXISTS `m_product`;
CREATE TABLE `m_product` (
  `id` int(11) NOT NULL,
  `start_date` int(11) DEFAULT '0' COMMENT '上架开始时间',
  `end_date` int(11) DEFAULT '0' COMMENT '上架结束时间'
) ENGINE=MyISAM AUTO_INCREMENT=126 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of m_product
-- ----------------------------
INSERT INTO `m_product` VALUES ('139', '0', '1999999999');
INSERT INTO `m_product` VALUES ('147', '0', '1999999999');
INSERT INTO `m_product` VALUES ('149', '0', '0');
INSERT INTO `m_product` VALUES ('151', '0', '1999999999');
INSERT INTO `m_product` VALUES ('152', '0', '1999999999');
INSERT INTO `m_product` VALUES ('155', '0', '0');
INSERT INTO `m_product` VALUES ('153', '0', '1999999999');
INSERT INTO `m_product` VALUES ('154', '0', '1999999999');
INSERT INTO `m_product` VALUES ('156', '0', '0');
INSERT INTO `m_product` VALUES ('150', '0', '0');
INSERT INTO `m_product` VALUES ('144', '0', '0');
INSERT INTO `m_product` VALUES ('145', '0', '0');
INSERT INTO `m_product` VALUES ('146', '0', '0');
INSERT INTO `m_product` VALUES ('194', '1448899200', '1464710400');
INSERT INTO `m_product` VALUES ('195', '1436284800', '1467907200');
INSERT INTO `m_product` VALUES ('201', '0', '1999999999');
INSERT INTO `m_product` VALUES ('203', '0', '1999999999');
INSERT INTO `m_product` VALUES ('202', '0', '1999999999');
INSERT INTO `m_product` VALUES ('204', '0', '1999999999');
INSERT INTO `m_product` VALUES ('205', '0', '1999999999');
INSERT INTO `m_product` VALUES ('206', '0', '1999999999');
INSERT INTO `m_product` VALUES ('207', '0', '1999999999');
INSERT INTO `m_product` VALUES ('212', '0', '1999999999');
INSERT INTO `m_product` VALUES ('211', '0', '1999999999');
INSERT INTO `m_product` VALUES ('209', '0', '1999999999');
INSERT INTO `m_product` VALUES ('208', '0', '1999999999');
INSERT INTO `m_product` VALUES ('210', '0', '1999999999');
INSERT INTO `m_product` VALUES ('213', '0', '1999999999');
INSERT INTO `m_product` VALUES ('214', '0', '1999999999');
INSERT INTO `m_product` VALUES ('215', '0', '1999999999');
INSERT INTO `m_product` VALUES ('216', '0', '1999999999');
INSERT INTO `m_product` VALUES ('217', '0', '1999999999');
INSERT INTO `m_product` VALUES ('218', '0', '1999999999');
INSERT INTO `m_product` VALUES ('219', '0', '1999999999');
INSERT INTO `m_product` VALUES ('220', '0', '1999999999');
INSERT INTO `m_product` VALUES ('221', '0', '1999999999');
INSERT INTO `m_product` VALUES ('222', '0', '1999999999');
INSERT INTO `m_product` VALUES ('223', '0', '1999999999');
INSERT INTO `m_product` VALUES ('246', '0', '1999999999');
INSERT INTO `m_product` VALUES ('224', '0', '1999999999');
INSERT INTO `m_product` VALUES ('225', '0', '1999999999');
INSERT INTO `m_product` VALUES ('226', '0', '1999999999');
INSERT INTO `m_product` VALUES ('228', '0', '1999999999');
INSERT INTO `m_product` VALUES ('229', '0', '1999999999');
INSERT INTO `m_product` VALUES ('230', '0', '1999999999');
INSERT INTO `m_product` VALUES ('231', '0', '1999999999');
INSERT INTO `m_product` VALUES ('232', '0', '1999999999');
INSERT INTO `m_product` VALUES ('233', '0', '1999999999');
INSERT INTO `m_product` VALUES ('234', '0', '1999999999');
INSERT INTO `m_product` VALUES ('235', '0', '1999999999');
INSERT INTO `m_product` VALUES ('236', '0', '1999999999');
INSERT INTO `m_product` VALUES ('237', '0', '1999999999');
INSERT INTO `m_product` VALUES ('238', '0', '1999999999');
INSERT INTO `m_product` VALUES ('239', '0', '1999999999');
INSERT INTO `m_product` VALUES ('240', '0', '1999999999');
INSERT INTO `m_product` VALUES ('241', '0', '1999999999');
INSERT INTO `m_product` VALUES ('242', '0', '1999999999');
INSERT INTO `m_product` VALUES ('243', '0', '1999999999');
INSERT INTO `m_product` VALUES ('247', '0', '1999999999');
INSERT INTO `m_product` VALUES ('250', '0', '1999999999');
INSERT INTO `m_product` VALUES ('251', '0', '1999999999');
INSERT INTO `m_product` VALUES ('252', '0', '1999999999');
INSERT INTO `m_product` VALUES ('253', '0', '1999999999');
INSERT INTO `m_product` VALUES ('254', '0', '1999999999');
INSERT INTO `m_product` VALUES ('255', '0', '1999999999');
INSERT INTO `m_product` VALUES ('256', '0', '1999999999');
INSERT INTO `m_product` VALUES ('257', '0', '1999999999');
INSERT INTO `m_product` VALUES ('258', '0', '1999999999');
INSERT INTO `m_product` VALUES ('259', '0', '1999999999');
INSERT INTO `m_product` VALUES ('260', '0', '1999999999');
INSERT INTO `m_product` VALUES ('261', '0', '1999999999');
INSERT INTO `m_product` VALUES ('262', '0', '1999999999');
INSERT INTO `m_product` VALUES ('263', '0', '1999999999');
INSERT INTO `m_product` VALUES ('264', '0', '1999999999');
INSERT INTO `m_product` VALUES ('265', '0', '1999999999');
INSERT INTO `m_product` VALUES ('266', '0', '1999999999');
INSERT INTO `m_product` VALUES ('267', '0', '1999999999');
INSERT INTO `m_product` VALUES ('268', '0', '1999999999');
INSERT INTO `m_product` VALUES ('269', '0', '0');
INSERT INTO `m_product` VALUES ('270', '0', '1999999999');
INSERT INTO `m_product` VALUES ('271', '0', '0');
INSERT INTO `m_product` VALUES ('272', '0', '1999999999');
INSERT INTO `m_product` VALUES ('273', '0', '1999999999');
INSERT INTO `m_product` VALUES ('0', '0', '0');
INSERT INTO `m_product` VALUES ('0', '0', '0');
INSERT INTO `m_product` VALUES ('140', '0', '0');

-- ----------------------------
-- Table structure for `m_productgroup_product`
-- ----------------------------
DROP TABLE IF EXISTS `m_productgroup_product`;
CREATE TABLE `m_productgroup_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` varchar(255) NOT NULL,
  `product_option_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=172 DEFAULT CHARSET=utf8 COMMENT='分类';

-- ----------------------------
-- Records of m_productgroup_product
-- ----------------------------
INSERT INTO `m_productgroup_product` VALUES ('158', '152', '1146');
INSERT INTO `m_productgroup_product` VALUES ('159', '153', '1147');
INSERT INTO `m_productgroup_product` VALUES ('160', '214', '1389');
INSERT INTO `m_productgroup_product` VALUES ('161', '214', '1390');
INSERT INTO `m_productgroup_product` VALUES ('157', '151', '1145');
INSERT INTO `m_productgroup_product` VALUES ('162', '214', '1391');
INSERT INTO `m_productgroup_product` VALUES ('163', '214', '1392');
INSERT INTO `m_productgroup_product` VALUES ('164', '214', '1393');
INSERT INTO `m_productgroup_product` VALUES ('165', '214', '1394');
INSERT INTO `m_productgroup_product` VALUES ('166', '214', '1395');
INSERT INTO `m_productgroup_product` VALUES ('167', '214', '1396');
INSERT INTO `m_productgroup_product` VALUES ('168', '214', '1397');
INSERT INTO `m_productgroup_product` VALUES ('169', '214', '1398');
INSERT INTO `m_productgroup_product` VALUES ('170', '214', '1399');
INSERT INTO `m_productgroup_product` VALUES ('171', '214', '1400');

-- ----------------------------
-- Table structure for `m_product_option`
-- ----------------------------
DROP TABLE IF EXISTS `m_product_option`;
CREATE TABLE `m_product_option` (
  `id` int(11) unsigned NOT NULL,
  `product_id` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=1007 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of m_product_option
-- ----------------------------
INSERT INTO `m_product_option` VALUES ('1078', '139');
INSERT INTO `m_product_option` VALUES ('1079', '139');
INSERT INTO `m_product_option` VALUES ('1080', '139');
INSERT INTO `m_product_option` VALUES ('1081', '139');
INSERT INTO `m_product_option` VALUES ('1082', '139');
INSERT INTO `m_product_option` VALUES ('1083', '139');
INSERT INTO `m_product_option` VALUES ('1084', '139');
INSERT INTO `m_product_option` VALUES ('1085', '139');
INSERT INTO `m_product_option` VALUES ('1086', '139');
INSERT INTO `m_product_option` VALUES ('1087', '139');
INSERT INTO `m_product_option` VALUES ('1088', '139');
INSERT INTO `m_product_option` VALUES ('1089', '139');
INSERT INTO `m_product_option` VALUES ('1090', '139');
INSERT INTO `m_product_option` VALUES ('1091', '139');
INSERT INTO `m_product_option` VALUES ('1092', '139');
INSERT INTO `m_product_option` VALUES ('1093', '139');
INSERT INTO `m_product_option` VALUES ('1094', '139');
INSERT INTO `m_product_option` VALUES ('1095', '139');
INSERT INTO `m_product_option` VALUES ('1096', '139');
INSERT INTO `m_product_option` VALUES ('1097', '139');
INSERT INTO `m_product_option` VALUES ('1150', '155');
INSERT INTO `m_product_option` VALUES ('1098', '139');
INSERT INTO `m_product_option` VALUES ('1099', '139');
INSERT INTO `m_product_option` VALUES ('1100', '139');
INSERT INTO `m_product_option` VALUES ('1101', '139');
INSERT INTO `m_product_option` VALUES ('1102', '139');
INSERT INTO `m_product_option` VALUES ('1103', '139');
INSERT INTO `m_product_option` VALUES ('1104', '139');
INSERT INTO `m_product_option` VALUES ('1148', '154');
INSERT INTO `m_product_option` VALUES ('1105', '139');
INSERT INTO `m_product_option` VALUES ('1106', '139');
INSERT INTO `m_product_option` VALUES ('1107', '139');
INSERT INTO `m_product_option` VALUES ('1108', '139');
INSERT INTO `m_product_option` VALUES ('1109', '139');
INSERT INTO `m_product_option` VALUES ('1147', '153');
INSERT INTO `m_product_option` VALUES ('1110', '139');
INSERT INTO `m_product_option` VALUES ('1149', '155');
INSERT INTO `m_product_option` VALUES ('1111', '139');
INSERT INTO `m_product_option` VALUES ('1143', '149');
INSERT INTO `m_product_option` VALUES ('1112', '139');
INSERT INTO `m_product_option` VALUES ('1113', '139');
INSERT INTO `m_product_option` VALUES ('1114', '139');
INSERT INTO `m_product_option` VALUES ('1115', '139');
INSERT INTO `m_product_option` VALUES ('1116', '139');
INSERT INTO `m_product_option` VALUES ('1117', '139');
INSERT INTO `m_product_option` VALUES ('1118', '139');
INSERT INTO `m_product_option` VALUES ('1119', '139');
INSERT INTO `m_product_option` VALUES ('1141', '147');
INSERT INTO `m_product_option` VALUES ('1120', '139');
INSERT INTO `m_product_option` VALUES ('1146', '152');
INSERT INTO `m_product_option` VALUES ('1121', '139');
INSERT INTO `m_product_option` VALUES ('1122', '139');
INSERT INTO `m_product_option` VALUES ('1123', '139');
INSERT INTO `m_product_option` VALUES ('1124', '139');
INSERT INTO `m_product_option` VALUES ('1125', '139');
INSERT INTO `m_product_option` VALUES ('1140', '147');
INSERT INTO `m_product_option` VALUES ('1126', '139');
INSERT INTO `m_product_option` VALUES ('1127', '139');
INSERT INTO `m_product_option` VALUES ('1128', '139');
INSERT INTO `m_product_option` VALUES ('1129', '139');
INSERT INTO `m_product_option` VALUES ('1145', '151');
INSERT INTO `m_product_option` VALUES ('1130', '139');
INSERT INTO `m_product_option` VALUES ('1131', '139');
INSERT INTO `m_product_option` VALUES ('1139', '147');
INSERT INTO `m_product_option` VALUES ('1151', '155');
INSERT INTO `m_product_option` VALUES ('1136', '144');
INSERT INTO `m_product_option` VALUES ('1152', '155');
INSERT INTO `m_product_option` VALUES ('1153', '155');
INSERT INTO `m_product_option` VALUES ('1154', '155');
INSERT INTO `m_product_option` VALUES ('1137', '145');
INSERT INTO `m_product_option` VALUES ('1138', '146');
INSERT INTO `m_product_option` VALUES ('1144', '150');
INSERT INTO `m_product_option` VALUES ('1155', '156');
INSERT INTO `m_product_option` VALUES ('1156', '156');
INSERT INTO `m_product_option` VALUES ('1157', '156');
INSERT INTO `m_product_option` VALUES ('1187', '195');
INSERT INTO `m_product_option` VALUES ('1188', '194');
INSERT INTO `m_product_option` VALUES ('1188', '194');
INSERT INTO `m_product_option` VALUES ('1188', '194');
INSERT INTO `m_product_option` VALUES ('1191', '195');
INSERT INTO `m_product_option` VALUES ('1192', '201');
INSERT INTO `m_product_option` VALUES ('1193', '201');
INSERT INTO `m_product_option` VALUES ('1194', '201');
INSERT INTO `m_product_option` VALUES ('1195', '201');
INSERT INTO `m_product_option` VALUES ('1196', '201');
INSERT INTO `m_product_option` VALUES ('1197', '201');
INSERT INTO `m_product_option` VALUES ('1198', '201');
INSERT INTO `m_product_option` VALUES ('1199', '201');
INSERT INTO `m_product_option` VALUES ('1200', '201');
INSERT INTO `m_product_option` VALUES ('1201', '201');
INSERT INTO `m_product_option` VALUES ('1202', '201');
INSERT INTO `m_product_option` VALUES ('1203', '201');
INSERT INTO `m_product_option` VALUES ('1204', '201');
INSERT INTO `m_product_option` VALUES ('1205', '201');
INSERT INTO `m_product_option` VALUES ('1206', '201');
INSERT INTO `m_product_option` VALUES ('1207', '201');
INSERT INTO `m_product_option` VALUES ('1208', '201');
INSERT INTO `m_product_option` VALUES ('1209', '201');
INSERT INTO `m_product_option` VALUES ('1231', '203');
INSERT INTO `m_product_option` VALUES ('1232', '203');
INSERT INTO `m_product_option` VALUES ('1210', '202');
INSERT INTO `m_product_option` VALUES ('1233', '203');
INSERT INTO `m_product_option` VALUES ('1234', '203');
INSERT INTO `m_product_option` VALUES ('1235', '203');
INSERT INTO `m_product_option` VALUES ('1236', '203');
INSERT INTO `m_product_option` VALUES ('1237', '203');
INSERT INTO `m_product_option` VALUES ('1238', '203');
INSERT INTO `m_product_option` VALUES ('1239', '203');
INSERT INTO `m_product_option` VALUES ('1211', '202');
INSERT INTO `m_product_option` VALUES ('1212', '202');
INSERT INTO `m_product_option` VALUES ('1213', '202');
INSERT INTO `m_product_option` VALUES ('1214', '202');
INSERT INTO `m_product_option` VALUES ('1244', '204');
INSERT INTO `m_product_option` VALUES ('1215', '202');
INSERT INTO `m_product_option` VALUES ('1216', '202');
INSERT INTO `m_product_option` VALUES ('1217', '202');
INSERT INTO `m_product_option` VALUES ('1218', '202');
INSERT INTO `m_product_option` VALUES ('1219', '202');
INSERT INTO `m_product_option` VALUES ('1243', '204');
INSERT INTO `m_product_option` VALUES ('1220', '202');
INSERT INTO `m_product_option` VALUES ('1261', '205');
INSERT INTO `m_product_option` VALUES ('1221', '202');
INSERT INTO `m_product_option` VALUES ('1222', '202');
INSERT INTO `m_product_option` VALUES ('1223', '202');
INSERT INTO `m_product_option` VALUES ('1242', '204');
INSERT INTO `m_product_option` VALUES ('1224', '202');
INSERT INTO `m_product_option` VALUES ('1225', '202');
INSERT INTO `m_product_option` VALUES ('1226', '202');
INSERT INTO `m_product_option` VALUES ('1241', '204');
INSERT INTO `m_product_option` VALUES ('1227', '202');
INSERT INTO `m_product_option` VALUES ('1228', '202');
INSERT INTO `m_product_option` VALUES ('1229', '202');
INSERT INTO `m_product_option` VALUES ('1230', '202');
INSERT INTO `m_product_option` VALUES ('1240', '204');
INSERT INTO `m_product_option` VALUES ('1245', '204');
INSERT INTO `m_product_option` VALUES ('1246', '204');
INSERT INTO `m_product_option` VALUES ('1247', '204');
INSERT INTO `m_product_option` VALUES ('1248', '204');
INSERT INTO `m_product_option` VALUES ('1260', '205');
INSERT INTO `m_product_option` VALUES ('1249', '204');
INSERT INTO `m_product_option` VALUES ('1250', '204');
INSERT INTO `m_product_option` VALUES ('1251', '204');
INSERT INTO `m_product_option` VALUES ('1252', '204');
INSERT INTO `m_product_option` VALUES ('1253', '204');
INSERT INTO `m_product_option` VALUES ('1259', '205');
INSERT INTO `m_product_option` VALUES ('1254', '204');
INSERT INTO `m_product_option` VALUES ('1269', '206');
INSERT INTO `m_product_option` VALUES ('1255', '204');
INSERT INTO `m_product_option` VALUES ('1256', '204');
INSERT INTO `m_product_option` VALUES ('1257', '204');
INSERT INTO `m_product_option` VALUES ('1258', '205');
INSERT INTO `m_product_option` VALUES ('1268', '206');
INSERT INTO `m_product_option` VALUES ('1262', '205');
INSERT INTO `m_product_option` VALUES ('1263', '205');
INSERT INTO `m_product_option` VALUES ('1264', '205');
INSERT INTO `m_product_option` VALUES ('1265', '205');
INSERT INTO `m_product_option` VALUES ('1266', '205');
INSERT INTO `m_product_option` VALUES ('1267', '206');
INSERT INTO `m_product_option` VALUES ('1270', '206');
INSERT INTO `m_product_option` VALUES ('1271', '206');
INSERT INTO `m_product_option` VALUES ('1272', '206');
INSERT INTO `m_product_option` VALUES ('1273', '206');
INSERT INTO `m_product_option` VALUES ('1332', '209');
INSERT INTO `m_product_option` VALUES ('1274', '206');
INSERT INTO `m_product_option` VALUES ('1275', '206');
INSERT INTO `m_product_option` VALUES ('1276', '206');
INSERT INTO `m_product_option` VALUES ('1277', '206');
INSERT INTO `m_product_option` VALUES ('1278', '206');
INSERT INTO `m_product_option` VALUES ('1279', '206');
INSERT INTO `m_product_option` VALUES ('1280', '206');
INSERT INTO `m_product_option` VALUES ('1281', '206');
INSERT INTO `m_product_option` VALUES ('1282', '206');
INSERT INTO `m_product_option` VALUES ('1283', '206');
INSERT INTO `m_product_option` VALUES ('1284', '206');
INSERT INTO `m_product_option` VALUES ('1285', '206');
INSERT INTO `m_product_option` VALUES ('1286', '206');
INSERT INTO `m_product_option` VALUES ('1293', '207');
INSERT INTO `m_product_option` VALUES ('1287', '206');
INSERT INTO `m_product_option` VALUES ('1288', '206');
INSERT INTO `m_product_option` VALUES ('1292', '207');
INSERT INTO `m_product_option` VALUES ('1289', '206');
INSERT INTO `m_product_option` VALUES ('1290', '206');
INSERT INTO `m_product_option` VALUES ('1291', '207');
INSERT INTO `m_product_option` VALUES ('1294', '207');
INSERT INTO `m_product_option` VALUES ('1295', '207');
INSERT INTO `m_product_option` VALUES ('1296', '207');
INSERT INTO `m_product_option` VALUES ('1327', '209');
INSERT INTO `m_product_option` VALUES ('1297', '207');
INSERT INTO `m_product_option` VALUES ('1298', '207');
INSERT INTO `m_product_option` VALUES ('1299', '207');
INSERT INTO `m_product_option` VALUES ('1300', '207');
INSERT INTO `m_product_option` VALUES ('1328', '209');
INSERT INTO `m_product_option` VALUES ('1301', '207');
INSERT INTO `m_product_option` VALUES ('1302', '207');
INSERT INTO `m_product_option` VALUES ('1303', '207');
INSERT INTO `m_product_option` VALUES ('1339', '210');
INSERT INTO `m_product_option` VALUES ('1329', '209');
INSERT INTO `m_product_option` VALUES ('1304', '207');
INSERT INTO `m_product_option` VALUES ('1305', '207');
INSERT INTO `m_product_option` VALUES ('1306', '207');
INSERT INTO `m_product_option` VALUES ('1331', '209');
INSERT INTO `m_product_option` VALUES ('1307', '207');
INSERT INTO `m_product_option` VALUES ('1308', '207');
INSERT INTO `m_product_option` VALUES ('1330', '209');
INSERT INTO `m_product_option` VALUES ('1333', '209');
INSERT INTO `m_product_option` VALUES ('1334', '209');
INSERT INTO `m_product_option` VALUES ('1335', '209');
INSERT INTO `m_product_option` VALUES ('1336', '209');
INSERT INTO `m_product_option` VALUES ('1337', '209');
INSERT INTO `m_product_option` VALUES ('1338', '209');
INSERT INTO `m_product_option` VALUES ('1309', '208');
INSERT INTO `m_product_option` VALUES ('1310', '208');
INSERT INTO `m_product_option` VALUES ('1311', '208');
INSERT INTO `m_product_option` VALUES ('1344', '210');
INSERT INTO `m_product_option` VALUES ('1312', '208');
INSERT INTO `m_product_option` VALUES ('1351', '211');
INSERT INTO `m_product_option` VALUES ('1313', '208');
INSERT INTO `m_product_option` VALUES ('1314', '208');
INSERT INTO `m_product_option` VALUES ('1315', '208');
INSERT INTO `m_product_option` VALUES ('1316', '208');
INSERT INTO `m_product_option` VALUES ('1343', '210');
INSERT INTO `m_product_option` VALUES ('1317', '208');
INSERT INTO `m_product_option` VALUES ('1318', '208');
INSERT INTO `m_product_option` VALUES ('1319', '208');
INSERT INTO `m_product_option` VALUES ('1342', '210');
INSERT INTO `m_product_option` VALUES ('1320', '208');
INSERT INTO `m_product_option` VALUES ('1321', '208');
INSERT INTO `m_product_option` VALUES ('1322', '208');
INSERT INTO `m_product_option` VALUES ('1341', '210');
INSERT INTO `m_product_option` VALUES ('1323', '208');
INSERT INTO `m_product_option` VALUES ('1324', '208');
INSERT INTO `m_product_option` VALUES ('1325', '208');
INSERT INTO `m_product_option` VALUES ('1340', '210');
INSERT INTO `m_product_option` VALUES ('1326', '208');
INSERT INTO `m_product_option` VALUES ('1345', '210');
INSERT INTO `m_product_option` VALUES ('1346', '210');
INSERT INTO `m_product_option` VALUES ('1347', '210');
INSERT INTO `m_product_option` VALUES ('1348', '210');
INSERT INTO `m_product_option` VALUES ('1349', '210');
INSERT INTO `m_product_option` VALUES ('1350', '210');
INSERT INTO `m_product_option` VALUES ('1352', '211');
INSERT INTO `m_product_option` VALUES ('1353', '211');
INSERT INTO `m_product_option` VALUES ('1354', '211');
INSERT INTO `m_product_option` VALUES ('1355', '211');
INSERT INTO `m_product_option` VALUES ('1356', '211');
INSERT INTO `m_product_option` VALUES ('1357', '211');
INSERT INTO `m_product_option` VALUES ('1358', '211');
INSERT INTO `m_product_option` VALUES ('1359', '211');
INSERT INTO `m_product_option` VALUES ('1360', '211');
INSERT INTO `m_product_option` VALUES ('1361', '211');
INSERT INTO `m_product_option` VALUES ('1362', '211');
INSERT INTO `m_product_option` VALUES ('1363', '211');
INSERT INTO `m_product_option` VALUES ('1364', '211');
INSERT INTO `m_product_option` VALUES ('1365', '212');
INSERT INTO `m_product_option` VALUES ('1366', '212');
INSERT INTO `m_product_option` VALUES ('1367', '212');
INSERT INTO `m_product_option` VALUES ('1368', '212');
INSERT INTO `m_product_option` VALUES ('1369', '212');
INSERT INTO `m_product_option` VALUES ('1370', '212');
INSERT INTO `m_product_option` VALUES ('1371', '212');
INSERT INTO `m_product_option` VALUES ('1372', '212');
INSERT INTO `m_product_option` VALUES ('1373', '212');
INSERT INTO `m_product_option` VALUES ('1374', '212');
INSERT INTO `m_product_option` VALUES ('1375', '212');
INSERT INTO `m_product_option` VALUES ('1376', '212');
INSERT INTO `m_product_option` VALUES ('1377', '212');
INSERT INTO `m_product_option` VALUES ('1378', '212');
INSERT INTO `m_product_option` VALUES ('1379', '212');
INSERT INTO `m_product_option` VALUES ('1380', '212');
INSERT INTO `m_product_option` VALUES ('1381', '212');
INSERT INTO `m_product_option` VALUES ('1382', '212');
INSERT INTO `m_product_option` VALUES ('1383', '213');
INSERT INTO `m_product_option` VALUES ('1384', '213');
INSERT INTO `m_product_option` VALUES ('1385', '213');
INSERT INTO `m_product_option` VALUES ('1386', '213');
INSERT INTO `m_product_option` VALUES ('1387', '213');
INSERT INTO `m_product_option` VALUES ('1388', '213');
INSERT INTO `m_product_option` VALUES ('1389', '214');
INSERT INTO `m_product_option` VALUES ('1390', '214');
INSERT INTO `m_product_option` VALUES ('1391', '214');
INSERT INTO `m_product_option` VALUES ('1392', '214');
INSERT INTO `m_product_option` VALUES ('1393', '214');
INSERT INTO `m_product_option` VALUES ('1394', '214');
INSERT INTO `m_product_option` VALUES ('1395', '214');
INSERT INTO `m_product_option` VALUES ('1396', '214');
INSERT INTO `m_product_option` VALUES ('1397', '214');
INSERT INTO `m_product_option` VALUES ('1398', '214');
INSERT INTO `m_product_option` VALUES ('1399', '214');
INSERT INTO `m_product_option` VALUES ('1400', '214');
INSERT INTO `m_product_option` VALUES ('1401', '215');
INSERT INTO `m_product_option` VALUES ('1402', '215');
INSERT INTO `m_product_option` VALUES ('1403', '215');
INSERT INTO `m_product_option` VALUES ('1404', '215');
INSERT INTO `m_product_option` VALUES ('1405', '215');
INSERT INTO `m_product_option` VALUES ('1406', '215');
INSERT INTO `m_product_option` VALUES ('1407', '215');
INSERT INTO `m_product_option` VALUES ('1408', '215');
INSERT INTO `m_product_option` VALUES ('1409', '215');
INSERT INTO `m_product_option` VALUES ('1410', '215');
INSERT INTO `m_product_option` VALUES ('1411', '215');
INSERT INTO `m_product_option` VALUES ('1412', '215');
INSERT INTO `m_product_option` VALUES ('1413', '216');
INSERT INTO `m_product_option` VALUES ('1414', '216');
INSERT INTO `m_product_option` VALUES ('1415', '216');
INSERT INTO `m_product_option` VALUES ('1416', '216');
INSERT INTO `m_product_option` VALUES ('1417', '216');
INSERT INTO `m_product_option` VALUES ('1418', '216');
INSERT INTO `m_product_option` VALUES ('1419', '217');
INSERT INTO `m_product_option` VALUES ('1420', '217');
INSERT INTO `m_product_option` VALUES ('1421', '217');
INSERT INTO `m_product_option` VALUES ('1422', '217');
INSERT INTO `m_product_option` VALUES ('1423', '217');
INSERT INTO `m_product_option` VALUES ('1424', '217');
INSERT INTO `m_product_option` VALUES ('1425', '217');
INSERT INTO `m_product_option` VALUES ('1426', '217');
INSERT INTO `m_product_option` VALUES ('1427', '217');
INSERT INTO `m_product_option` VALUES ('1428', '217');
INSERT INTO `m_product_option` VALUES ('1429', '217');
INSERT INTO `m_product_option` VALUES ('1430', '217');
INSERT INTO `m_product_option` VALUES ('1431', '218');
INSERT INTO `m_product_option` VALUES ('1432', '218');
INSERT INTO `m_product_option` VALUES ('1433', '218');
INSERT INTO `m_product_option` VALUES ('1448', '219');
INSERT INTO `m_product_option` VALUES ('1434', '218');
INSERT INTO `m_product_option` VALUES ('1459', '220');
INSERT INTO `m_product_option` VALUES ('1435', '218');
INSERT INTO `m_product_option` VALUES ('1436', '218');
INSERT INTO `m_product_option` VALUES ('1437', '218');
INSERT INTO `m_product_option` VALUES ('1438', '218');
INSERT INTO `m_product_option` VALUES ('1439', '218');
INSERT INTO `m_product_option` VALUES ('1440', '218');
INSERT INTO `m_product_option` VALUES ('1441', '218');
INSERT INTO `m_product_option` VALUES ('1442', '218');
INSERT INTO `m_product_option` VALUES ('1443', '218');
INSERT INTO `m_product_option` VALUES ('1444', '218');
INSERT INTO `m_product_option` VALUES ('1445', '218');
INSERT INTO `m_product_option` VALUES ('1446', '218');
INSERT INTO `m_product_option` VALUES ('1447', '219');
INSERT INTO `m_product_option` VALUES ('1449', '219');
INSERT INTO `m_product_option` VALUES ('1450', '219');
INSERT INTO `m_product_option` VALUES ('1451', '219');
INSERT INTO `m_product_option` VALUES ('1452', '219');
INSERT INTO `m_product_option` VALUES ('1453', '219');
INSERT INTO `m_product_option` VALUES ('1454', '219');
INSERT INTO `m_product_option` VALUES ('1455', '219');
INSERT INTO `m_product_option` VALUES ('1456', '219');
INSERT INTO `m_product_option` VALUES ('1457', '219');
INSERT INTO `m_product_option` VALUES ('1458', '219');
INSERT INTO `m_product_option` VALUES ('1460', '220');
INSERT INTO `m_product_option` VALUES ('1461', '220');
INSERT INTO `m_product_option` VALUES ('1462', '220');
INSERT INTO `m_product_option` VALUES ('1463', '220');
INSERT INTO `m_product_option` VALUES ('1464', '220');
INSERT INTO `m_product_option` VALUES ('1465', '220');
INSERT INTO `m_product_option` VALUES ('1466', '220');
INSERT INTO `m_product_option` VALUES ('1467', '220');
INSERT INTO `m_product_option` VALUES ('1468', '220');
INSERT INTO `m_product_option` VALUES ('1469', '220');
INSERT INTO `m_product_option` VALUES ('1470', '220');
INSERT INTO `m_product_option` VALUES ('1471', '221');
INSERT INTO `m_product_option` VALUES ('1472', '222');
INSERT INTO `m_product_option` VALUES ('1473', '222');
INSERT INTO `m_product_option` VALUES ('1474', '222');
INSERT INTO `m_product_option` VALUES ('1475', '222');
INSERT INTO `m_product_option` VALUES ('1491', '223');
INSERT INTO `m_product_option` VALUES ('1476', '222');
INSERT INTO `m_product_option` VALUES ('1477', '222');
INSERT INTO `m_product_option` VALUES ('1478', '222');
INSERT INTO `m_product_option` VALUES ('1479', '222');
INSERT INTO `m_product_option` VALUES ('1480', '222');
INSERT INTO `m_product_option` VALUES ('1481', '222');
INSERT INTO `m_product_option` VALUES ('1482', '222');
INSERT INTO `m_product_option` VALUES ('1483', '222');
INSERT INTO `m_product_option` VALUES ('1484', '222');
INSERT INTO `m_product_option` VALUES ('1485', '222');
INSERT INTO `m_product_option` VALUES ('1486', '222');
INSERT INTO `m_product_option` VALUES ('1487', '222');
INSERT INTO `m_product_option` VALUES ('1488', '222');
INSERT INTO `m_product_option` VALUES ('1489', '222');
INSERT INTO `m_product_option` VALUES ('1490', '223');
INSERT INTO `m_product_option` VALUES ('1492', '223');
INSERT INTO `m_product_option` VALUES ('1493', '223');
INSERT INTO `m_product_option` VALUES ('1494', '223');
INSERT INTO `m_product_option` VALUES ('1495', '223');
INSERT INTO `m_product_option` VALUES ('1496', '223');
INSERT INTO `m_product_option` VALUES ('1497', '223');
INSERT INTO `m_product_option` VALUES ('1498', '223');
INSERT INTO `m_product_option` VALUES ('1499', '223');
INSERT INTO `m_product_option` VALUES ('1500', '223');
INSERT INTO `m_product_option` VALUES ('1501', '223');
INSERT INTO `m_product_option` VALUES ('1502', '224');
INSERT INTO `m_product_option` VALUES ('1503', '224');
INSERT INTO `m_product_option` VALUES ('1504', '224');
INSERT INTO `m_product_option` VALUES ('1505', '224');
INSERT INTO `m_product_option` VALUES ('1506', '224');
INSERT INTO `m_product_option` VALUES ('1507', '224');
INSERT INTO `m_product_option` VALUES ('1508', '224');
INSERT INTO `m_product_option` VALUES ('1509', '224');
INSERT INTO `m_product_option` VALUES ('1510', '224');
INSERT INTO `m_product_option` VALUES ('1511', '224');
INSERT INTO `m_product_option` VALUES ('1512', '224');
INSERT INTO `m_product_option` VALUES ('1513', '224');
INSERT INTO `m_product_option` VALUES ('1514', '225');
INSERT INTO `m_product_option` VALUES ('1515', '225');
INSERT INTO `m_product_option` VALUES ('1516', '225');
INSERT INTO `m_product_option` VALUES ('1517', '225');
INSERT INTO `m_product_option` VALUES ('1518', '225');
INSERT INTO `m_product_option` VALUES ('1519', '225');
INSERT INTO `m_product_option` VALUES ('1520', '225');
INSERT INTO `m_product_option` VALUES ('1521', '225');
INSERT INTO `m_product_option` VALUES ('1522', '225');
INSERT INTO `m_product_option` VALUES ('1523', '225');
INSERT INTO `m_product_option` VALUES ('1524', '225');
INSERT INTO `m_product_option` VALUES ('1525', '225');
INSERT INTO `m_product_option` VALUES ('1526', '225');
INSERT INTO `m_product_option` VALUES ('1527', '225');
INSERT INTO `m_product_option` VALUES ('1528', '225');
INSERT INTO `m_product_option` VALUES ('1529', '225');
INSERT INTO `m_product_option` VALUES ('1530', '225');
INSERT INTO `m_product_option` VALUES ('1531', '225');
INSERT INTO `m_product_option` VALUES ('1532', '226');
INSERT INTO `m_product_option` VALUES ('1533', '226');
INSERT INTO `m_product_option` VALUES ('1534', '226');
INSERT INTO `m_product_option` VALUES ('1535', '226');
INSERT INTO `m_product_option` VALUES ('1536', '226');
INSERT INTO `m_product_option` VALUES ('1537', '226');
INSERT INTO `m_product_option` VALUES ('1538', '226');
INSERT INTO `m_product_option` VALUES ('1539', '226');
INSERT INTO `m_product_option` VALUES ('1540', '226');
INSERT INTO `m_product_option` VALUES ('1541', '226');
INSERT INTO `m_product_option` VALUES ('1542', '226');
INSERT INTO `m_product_option` VALUES ('1543', '226');
INSERT INTO `m_product_option` VALUES ('1545', '228');
INSERT INTO `m_product_option` VALUES ('1546', '229');
INSERT INTO `m_product_option` VALUES ('1547', '230');
INSERT INTO `m_product_option` VALUES ('1548', '231');
INSERT INTO `m_product_option` VALUES ('1549', '232');
INSERT INTO `m_product_option` VALUES ('1550', '233');
INSERT INTO `m_product_option` VALUES ('1551', '234');
INSERT INTO `m_product_option` VALUES ('1552', '235');
INSERT INTO `m_product_option` VALUES ('1553', '236');
INSERT INTO `m_product_option` VALUES ('1554', '237');
INSERT INTO `m_product_option` VALUES ('1555', '238');
INSERT INTO `m_product_option` VALUES ('1556', '239');
INSERT INTO `m_product_option` VALUES ('1557', '239');
INSERT INTO `m_product_option` VALUES ('1558', '239');
INSERT INTO `m_product_option` VALUES ('1559', '239');
INSERT INTO `m_product_option` VALUES ('1560', '239');
INSERT INTO `m_product_option` VALUES ('1561', '239');
INSERT INTO `m_product_option` VALUES ('1562', '239');
INSERT INTO `m_product_option` VALUES ('1563', '239');
INSERT INTO `m_product_option` VALUES ('1564', '239');
INSERT INTO `m_product_option` VALUES ('1565', '239');
INSERT INTO `m_product_option` VALUES ('1566', '239');
INSERT INTO `m_product_option` VALUES ('1567', '239');
INSERT INTO `m_product_option` VALUES ('1568', '239');
INSERT INTO `m_product_option` VALUES ('1569', '239');
INSERT INTO `m_product_option` VALUES ('1570', '239');
INSERT INTO `m_product_option` VALUES ('1571', '239');
INSERT INTO `m_product_option` VALUES ('1572', '239');
INSERT INTO `m_product_option` VALUES ('1573', '239');
INSERT INTO `m_product_option` VALUES ('1574', '239');
INSERT INTO `m_product_option` VALUES ('1575', '239');
INSERT INTO `m_product_option` VALUES ('1576', '239');
INSERT INTO `m_product_option` VALUES ('1577', '239');
INSERT INTO `m_product_option` VALUES ('1578', '239');
INSERT INTO `m_product_option` VALUES ('1579', '239');
INSERT INTO `m_product_option` VALUES ('1580', '240');
INSERT INTO `m_product_option` VALUES ('1581', '240');
INSERT INTO `m_product_option` VALUES ('1582', '240');
INSERT INTO `m_product_option` VALUES ('1583', '240');
INSERT INTO `m_product_option` VALUES ('1584', '240');
INSERT INTO `m_product_option` VALUES ('1585', '240');
INSERT INTO `m_product_option` VALUES ('1586', '240');
INSERT INTO `m_product_option` VALUES ('1587', '240');
INSERT INTO `m_product_option` VALUES ('1588', '240');
INSERT INTO `m_product_option` VALUES ('1589', '240');
INSERT INTO `m_product_option` VALUES ('1590', '240');
INSERT INTO `m_product_option` VALUES ('1591', '240');
INSERT INTO `m_product_option` VALUES ('1592', '240');
INSERT INTO `m_product_option` VALUES ('1593', '240');
INSERT INTO `m_product_option` VALUES ('1594', '240');
INSERT INTO `m_product_option` VALUES ('1595', '240');
INSERT INTO `m_product_option` VALUES ('1596', '241');
INSERT INTO `m_product_option` VALUES ('1597', '241');
INSERT INTO `m_product_option` VALUES ('1598', '241');
INSERT INTO `m_product_option` VALUES ('1599', '241');
INSERT INTO `m_product_option` VALUES ('1600', '241');
INSERT INTO `m_product_option` VALUES ('1601', '241');
INSERT INTO `m_product_option` VALUES ('1602', '241');
INSERT INTO `m_product_option` VALUES ('1603', '241');
INSERT INTO `m_product_option` VALUES ('1604', '241');
INSERT INTO `m_product_option` VALUES ('1605', '241');
INSERT INTO `m_product_option` VALUES ('1606', '241');
INSERT INTO `m_product_option` VALUES ('1607', '241');
INSERT INTO `m_product_option` VALUES ('1608', '241');
INSERT INTO `m_product_option` VALUES ('1609', '241');
INSERT INTO `m_product_option` VALUES ('1610', '241');
INSERT INTO `m_product_option` VALUES ('1611', '241');
INSERT INTO `m_product_option` VALUES ('1612', '241');
INSERT INTO `m_product_option` VALUES ('1613', '241');
INSERT INTO `m_product_option` VALUES ('1614', '241');
INSERT INTO `m_product_option` VALUES ('1615', '241');
INSERT INTO `m_product_option` VALUES ('1616', '241');
INSERT INTO `m_product_option` VALUES ('1617', '241');
INSERT INTO `m_product_option` VALUES ('1618', '241');
INSERT INTO `m_product_option` VALUES ('1619', '241');
INSERT INTO `m_product_option` VALUES ('1620', '242');
INSERT INTO `m_product_option` VALUES ('1621', '242');
INSERT INTO `m_product_option` VALUES ('1622', '242');
INSERT INTO `m_product_option` VALUES ('1623', '242');
INSERT INTO `m_product_option` VALUES ('1624', '242');
INSERT INTO `m_product_option` VALUES ('1625', '242');
INSERT INTO `m_product_option` VALUES ('1626', '242');
INSERT INTO `m_product_option` VALUES ('1627', '242');
INSERT INTO `m_product_option` VALUES ('1628', '242');
INSERT INTO `m_product_option` VALUES ('1629', '242');
INSERT INTO `m_product_option` VALUES ('1630', '242');
INSERT INTO `m_product_option` VALUES ('1631', '242');
INSERT INTO `m_product_option` VALUES ('1632', '242');
INSERT INTO `m_product_option` VALUES ('1633', '242');
INSERT INTO `m_product_option` VALUES ('1634', '242');
INSERT INTO `m_product_option` VALUES ('1635', '242');
INSERT INTO `m_product_option` VALUES ('1636', '243');
INSERT INTO `m_product_option` VALUES ('1637', '243');
INSERT INTO `m_product_option` VALUES ('1638', '243');
INSERT INTO `m_product_option` VALUES ('1639', '243');
INSERT INTO `m_product_option` VALUES ('1649', '246');
INSERT INTO `m_product_option` VALUES ('1650', '246');
INSERT INTO `m_product_option` VALUES ('1651', '246');
INSERT INTO `m_product_option` VALUES ('1667', '250');
INSERT INTO `m_product_option` VALUES ('1652', '247');
INSERT INTO `m_product_option` VALUES ('1668', '250');
INSERT INTO `m_product_option` VALUES ('1653', '247');
INSERT INTO `m_product_option` VALUES ('1654', '247');
INSERT INTO `m_product_option` VALUES ('1669', '250');
INSERT INTO `m_product_option` VALUES ('1667', '250');
INSERT INTO `m_product_option` VALUES ('1668', '250');
INSERT INTO `m_product_option` VALUES ('1669', '250');
INSERT INTO `m_product_option` VALUES ('1670', '251');
INSERT INTO `m_product_option` VALUES ('1671', '251');
INSERT INTO `m_product_option` VALUES ('1672', '251');
INSERT INTO `m_product_option` VALUES ('1670', '251');
INSERT INTO `m_product_option` VALUES ('1671', '251');
INSERT INTO `m_product_option` VALUES ('1672', '251');
INSERT INTO `m_product_option` VALUES ('1673', '252');
INSERT INTO `m_product_option` VALUES ('1674', '252');
INSERT INTO `m_product_option` VALUES ('1675', '252');
INSERT INTO `m_product_option` VALUES ('1673', '252');
INSERT INTO `m_product_option` VALUES ('1674', '252');
INSERT INTO `m_product_option` VALUES ('1675', '252');
INSERT INTO `m_product_option` VALUES ('1676', '253');
INSERT INTO `m_product_option` VALUES ('1677', '253');
INSERT INTO `m_product_option` VALUES ('1678', '253');
INSERT INTO `m_product_option` VALUES ('1676', '253');
INSERT INTO `m_product_option` VALUES ('1677', '253');
INSERT INTO `m_product_option` VALUES ('1678', '253');
INSERT INTO `m_product_option` VALUES ('1679', '254');
INSERT INTO `m_product_option` VALUES ('1680', '254');
INSERT INTO `m_product_option` VALUES ('1681', '254');
INSERT INTO `m_product_option` VALUES ('1679', '254');
INSERT INTO `m_product_option` VALUES ('1680', '254');
INSERT INTO `m_product_option` VALUES ('1681', '254');
INSERT INTO `m_product_option` VALUES ('1682', '255');
INSERT INTO `m_product_option` VALUES ('1683', '255');
INSERT INTO `m_product_option` VALUES ('1684', '255');
INSERT INTO `m_product_option` VALUES ('1682', '255');
INSERT INTO `m_product_option` VALUES ('1683', '255');
INSERT INTO `m_product_option` VALUES ('1684', '255');
INSERT INTO `m_product_option` VALUES ('1685', '256');
INSERT INTO `m_product_option` VALUES ('1686', '257');
INSERT INTO `m_product_option` VALUES ('1687', '258');
INSERT INTO `m_product_option` VALUES ('1688', '259');
INSERT INTO `m_product_option` VALUES ('1689', '260');
INSERT INTO `m_product_option` VALUES ('1690', '261');
INSERT INTO `m_product_option` VALUES ('1691', '262');
INSERT INTO `m_product_option` VALUES ('1692', '263');
INSERT INTO `m_product_option` VALUES ('1693', '264');
INSERT INTO `m_product_option` VALUES ('1694', '265');
INSERT INTO `m_product_option` VALUES ('1695', '266');
INSERT INTO `m_product_option` VALUES ('1696', '267');
INSERT INTO `m_product_option` VALUES ('1697', '267');
INSERT INTO `m_product_option` VALUES ('1698', '268');
INSERT INTO `m_product_option` VALUES ('1699', '268');
INSERT INTO `m_product_option` VALUES ('1700', '269');
INSERT INTO `m_product_option` VALUES ('1701', '270');
INSERT INTO `m_product_option` VALUES ('1702', '271');
INSERT INTO `m_product_option` VALUES ('1703', '272');
INSERT INTO `m_product_option` VALUES ('1704', '273');
INSERT INTO `m_product_option` VALUES ('1705', '273');
INSERT INTO `m_product_option` VALUES ('1132', '140');






www.htsjk.Com true http://www.htsjk.com/mariadb/29890.html NewsArticle MariaDB(mysql)排序诡异问题,mariadbmysql排序 这是一个比较诡异的问题 这样的一句SQL, 在不同的mysql版本中,返回的结果是不同的 。 并且5.5.37-MariaDB这个版本数据库,每次的结果都会随...
相关文章
    暂无相关文章
评论暂时关闭