CREATE DEFINER=`root`@`localhost` PROCEDURE `pro_sort2()`
BEGIN
DECLARE memberId INT ;
DECLARE cur_sort INT ;
DECLARE b_sort INT ;
DECLARE lnumber INT ;
DECLARE sort INT ;
DECLARE id INT ;
DECLARE STOP INT DEFAULT 0;
DECLARE cnt INT DEFAULT 0;
DECLARE tempId INT DEFAULT 0;
DECLARE maxId INT DEFAULT 0;
DECLARE flag INT DEFAULT 0;
DECLARE tId INT DEFAULT 0;
DECLARE asql varchar(500); DECLARE cur CURSOR FOR select id,memberId , sort from noGoodsPoint g inner join memberinfo m on m.memberid=g.memberid order by m.points desc ;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET STOP=1;
set b_sort=0;
SELECT loopNumber INTO lnumber FROM tbl_loop;
OPEN cur;
FETCH cur INTO id, memberId,cur_sort ;
WHILE STOP <> 1 DO
set sort=0 ;
-- select sort into sort from nogoodspoint; --where sort< cur_sort and memberId= memberId order by sort limit 0,1
if cur_sort<(lnumber+sort) then
update nogoodspoint set sort= sort+lnumber where id=id ;
else
update nogoodspoint set sort=b_sort+1 where id=id;
end if;
set b_sort=sort;
FETCH cur INTO id, memberId,cur_sort ;
END WHILE;
CLOSE cur;
end;
BEGIN
DECLARE memberId INT ;
DECLARE cur_sort INT ;
DECLARE b_sort INT ;
DECLARE lnumber INT ;
DECLARE sort INT ;
DECLARE id INT ;
DECLARE STOP INT DEFAULT 0;
DECLARE cnt INT DEFAULT 0;
DECLARE tempId INT DEFAULT 0;
DECLARE maxId INT DEFAULT 0;
DECLARE flag INT DEFAULT 0;
DECLARE tId INT DEFAULT 0;
DECLARE asql varchar(500); DECLARE cur CURSOR FOR select id,memberId , sort from noGoodsPoint g inner join memberinfo m on m.memberid=g.memberid order by m.points desc ;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET STOP=1;
set b_sort=0;
SELECT loopNumber INTO lnumber FROM tbl_loop;
OPEN cur;
FETCH cur INTO id, memberId,cur_sort ;
WHILE STOP <> 1 DO
set sort=0 ;
-- select sort into sort from nogoodspoint; --where sort< cur_sort and memberId= memberId order by sort limit 0,1
if cur_sort<(lnumber+sort) then
update nogoodspoint set sort= sort+lnumber where id=id ;
else
update nogoodspoint set sort=b_sort+1 where id=id;
end if;
set b_sort=sort;
FETCH cur INTO id, memberId,cur_sort ;
END WHILE;
CLOSE cur;
end;
DROP PROCEDURE IF EXISTS `pro_sort2`$$
CREATE PROCEDURE `pro_sort2`()
BEGIN
DECLARE memberId INT ;
DECLARE cur_sort INT ;
DECLARE b_sort INT ;
DECLARE lnumber INT ;
DECLARE sort INT ;
DECLARE id INT ;
DECLARE STOP INT DEFAULT 0;
DECLARE cnt INT DEFAULT 0;
DECLARE tempId INT DEFAULT 0;
DECLARE maxId INT DEFAULT 0;
DECLARE flag INT DEFAULT 0;
DECLARE tId INT DEFAULT 0;
DECLARE asql VARCHAR(500);
DECLARE cur CURSOR FOR SELECT id,memberId , sort FROM noGoodsPoint g INNER JOIN memberinfo m ON m.memberid=g.memberid ORDER BY m.points DESC ;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET STOP=1;
SET b_sort=0;
SELECT loopNumber INTO lnumber FROM tbl_loop;
OPEN cur;
FETCH cur INTO id, memberId,cur_sort ;
WHILE STOP <> 1 DO
SET sort=0 ;
-- select sort into sort from nogoodspoint; --where sort< cur_sort and memberId= memberId order by sort limit 0,1
IF cur_sort<(lnumber+sort) THEN
UPDATE nogoodspoint SET sort= sort+lnumber WHERE id=id ;
ELSE
UPDATE nogoodspoint SET sort=b_sort+1 WHERE id=id;
END IF;
SET b_sort=sort;
FETCH cur INTO id, memberId,cur_sort ;
END WHILE;
CLOSE cur;
END$$
DELIMITER ;
SET sorts=0;
select sort into sorts from nogoodspoint;
我这样试怎么都不好使呢?
select sort into sorts from nogoodspoint where id=1;
CREATE PROCEDURE `pro_sort2`()
BEGIN
DECLARE cur_memberId INT ;
DECLARE cur_sort INT ;
DECLARE b_sort INT ;
DECLARE lnumber INT ;
DECLARE sorts INT;
DECLARE cur_id INT ;
DECLARE STOP INT DEFAULT 0;
DECLARE cnt INT DEFAULT 0;
DECLARE tempId INT DEFAULT 0;
DECLARE maxId INT DEFAULT 0;
DECLARE flag INT DEFAULT 0;
DECLARE tId INT DEFAULT 0;
DECLARE asql VARCHAR(500);
DECLARE cur CURSOR FOR SELECT goodspointId,g.memberId , sortNo FROM noGoodsPoint g INNER JOIN memberinfo m ON m.memberid=g.memberid ORDER BY m.points DESC ;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET STOP=1;
SET b_sort=0;
SELECT loopNumber INTO lnumber FROM tbl_loop;
OPEN cur;
FETCH cur INTO cur_id, cur_memberId,cur_sort ;
WHILE STOP <> 1 DO
SET sorts=0;
-- select sortNo into sorts from nogoodspoint where sortNo< cur_sort and memberId= memberId order by sortNo limit 0,1 ;
IF cur_sort<(lnumber+ sorts) THEN
UPDATE nogoodspoint SET sortNo= sortNo+lnumber WHERE goodspointId=cur_id ;
select 'if' ;
ELSE
UPDATE nogoodspoint SET sortNo=b_sort+1 WHERE goodspointId=cur_id;
select 'else' ;
END IF;
SET b_sort=sorts;
FETCH cur INTO cur_id, cur_memberId,cur_sort ;
END WHILE;
CLOSE cur;
END
--call pro_sort2--update nogoodspoint set sortNo=0为什么我加了这句
-- select sortNo into sorts from nogoodspoint where sortNo< cur_sort and memberId= memberId order by sortNo limit 0,1 ;
好像这句查询不到结果,下面就不执行了呢?
OPEN cur;
FETCH cur INTO cur_id, cur_memberId,cur_sort ;
WHILE STOP <> 1 DO
SET sorts=0;
select sortNo into sorts from nogoodspoint where sortNo< cur_sort and memberId= memberId order by sortNo limit 0,1 ;
set STOP=0;
IF cur_sort<(lnumber+ sorts) THEN
UPDATE nogoodspoint SET sortNo= sortNo+lnumber WHERE goodspointId=cur_id ; ==============
加上这句 set STOP=0;
这样当select sortNo into sorts from nogoodspoint where sortNo< cur_sort and memberId= memberId order by sortNo limit 0,1 ; 没有记录返回时,就会触发 SQLSTATE '02000' SET STOP=1;
检查是否 有满足条件的记录,如果没有,要影响到游标的循环
SET stop=0;
让游标继续循环
if sorts=0 or cur_sort>(lnumber+ sorts) then
UPDATE nogoodspoint SET sortNo=b_sort+1 WHERE goodspointId=cur_id;
else cur_sort<(lnumber+ sorts) THEN
UPDATE nogoodspoint SET sortNo= sortNo+lnumber WHERE goodspointId=cur_id ;
end if;这样写又怎么错了?
UPDATE nogoodspoint SET sortNo=b_sort+1 WHERE goodspointId=cur_id;
elseif cur_sort<(lnumber+ sorts) THEN
UPDATE nogoodspoint SET sortNo= sortNo+lnumber WHERE goodspointId=cur_id ;
end if;
UPDATE nogoodspoint SET sortNo=b_sort+1 WHERE goodspointId=cur_id;
else
UPDATE nogoodspoint SET sortNo= sortNo+lnumber WHERE goodspointId=cur_id ;
end if;
if sorts=0 then
set up_sort= b_sort;
elseif sorts<>0 and b_sort>(lnumber+ sorts) then
set up_sort= b_sort;
elseif sorts<>0 and b_sort<(lnumber+ sorts) THEN
set up_sort= sortNo+lnumber;
end if;
select b_sort;
select cur_memberId;
select sorts;
select up_sort; UPDATE nogoodspoint SET sortNo= b_sort WHERE goodspointId=cur_id ;
set b_sort=b_sort+1; UPDATE nogoodspoint SET sortNo= b_sort WHERE goodspointId=cur_id ;
加上这句就报这个错
怎么回事?nogoodspoint 里有sortNo这个字段呀?
---------------------------
错误
---------------------------
SQL 执行错误 # 1054. 从数据库的响应:Unknown column 'sortNo' in 'field list'
---------------------------
确定
---------------------------
--drop PROCEDURE `pro_sort2`
CREATE PROCEDURE `pro_sort2`()
BEGIN
DECLARE cur_memberId INT ;
DECLARE cur_sort INT ;
DECLARE b_sort INT DEFAULT 1;
DECLARE lnumber INT ;
DECLARE sorts INT;
DECLARE cur_id INT ;
DECLARE up_sort INT ;
DECLARE STOP INT DEFAULT 0;
DECLARE cnt INT DEFAULT 0;
DECLARE tempId INT DEFAULT 0;
DECLARE maxId INT DEFAULT 0;
DECLARE flag INT DEFAULT 0;
DECLARE tId INT DEFAULT 0;
DECLARE asql VARCHAR(500);
DECLARE cur CURSOR FOR SELECT goodspointId,g.memberId , sortNo FROM noGoodsPoint g INNER JOIN memberinfo m ON m.memberid=g.memberid ORDER BY m.points DESC ;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET STOP=1; SELECT loopNumber INTO lnumber FROM tbl_loop;
OPEN cur;
FETCH cur INTO cur_id, cur_memberId,cur_sort ;
WHILE STOP <> 1 DO
SET sorts=0;
select sortNo into sorts from nogoodspoint where sortNo<= b_sort and memberId= cur_memberId order by sortNo limit 0,1 ; set STOP=0;
if sorts=0 then
set up_sort= b_sort;
elseif sorts<>0 and b_sort>(lnumber+ sorts) then
set up_sort= b_sort;
elseif sorts<>0 and b_sort<(lnumber+ sorts) THEN
set up_sort= sortNo+lnumber;
end if;
select b_sort;
select cur_memberId;
select sorts;
select up_sort; UPDATE nogoodspoint SET sortNo= up_sort WHERE goodspointId=cur_id ;
set b_sort=b_sort+1; FETCH cur INTO cur_id, cur_memberId,cur_sort ;
END WHILE;
CLOSE cur;
END
--call pro_sort2
--update nogoodspoint set sortNo=0;
全文是这样的
贴结果
错误
---------------------------
SQL 执行错误 # 1054. 从数据库的响应:Unknown column 'sortNo' in 'field list'
---------------------------
确定
---------------------------
还是这样呀? desc nogoodspoint 这是啥意思呀,放上也不好使呀?
在MYSQL中运行
desc nogoodspoint
CREATE TABLE `nogoodspoint` (
`goodsPointId` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '积分商品的编号',
`goodsId` varchar(20) DEFAULT NULL COMMENT '商品的编号',
`memberId` int(11) unsigned DEFAULT NULL COMMENT '购买该商品的会员的编号',
`consumerId` int(11) unsigned DEFAULT NULL COMMENT '消费的编号',
`canPoints` int(6) unsigned DEFAULT NULL COMMENT '可积分数(一分钱一积分)',
`totalPoints` int(11) unsigned DEFAULT NULL COMMENT '该商品的满积分',
`sortNo` int(11) DEFAULT '0',
PRIMARY KEY (`goodsPointId`),
UNIQUE KEY `goodsPointId` (`goodsPointId`)
) ENGINE=InnoDB AUTO_INCREMENT=305 DEFAULT CHARSET=gbk COMMENT='尚未添加到积分类表的交易';desc nogoodspoint还是没明白。表是这样的。
Update nogoodspoint set sortNo=0;
能否通过
UPDATE nogoodspoint SET sortNo=up_sort WHERE goodspointId=cur_id ;->
UPDATE nogoodspoint SET sortNo=0 WHERE goodspointId=cur_id ;
能否通过
UPDATE nogoodspoint SET sortNo=0 WHERE goodspointId=cur_id ;
没有提示出错,数据库没有问题吧
INSERT INTO `nogoodspoint` VALUES (132,'031',1620,2101,90,1000,21);
INSERT INTO `nogoodspoint` VALUES (133,'077',1772,2102,70,800,160);
INSERT INTO `nogoodspoint` VALUES (134,'037',1773,2103,150,1600,171);
INSERT INTO `nogoodspoint` VALUES (135,'036',1774,2104,140,1500,31);
INSERT INTO `nogoodspoint` VALUES (136,'035',1775,2105,130,1400,44);
INSERT INTO `nogoodspoint` VALUES (137,'031',1750,2106,90,1000,14);
INSERT INTO `nogoodspoint` VALUES (138,'077',1776,2107,70,800,68);
INSERT INTO `nogoodspoint` VALUES (140,'078',1656,2109,20,300,10);
INSERT INTO `nogoodspoint` VALUES (141,'078',1657,2110,20,300,3);
INSERT INTO `nogoodspoint` VALUES (143,'043',1778,2112,210,2200,102);
INSERT INTO `nogoodspoint` VALUES (144,'0001',1779,2113,29,400,115);
INSERT INTO `nogoodspoint` VALUES (145,'036',1780,2114,140,1500,127);
INSERT INTO `nogoodspoint` VALUES (146,'031',1782,2115,90,1000,141);
INSERT INTO `nogoodspoint` VALUES (147,'034',1782,2116,119,1300,150);
INSERT INTO `nogoodspoint` VALUES (148,'037',1783,2117,150,1600,162);
INSERT INTO `nogoodspoint` VALUES (149,'077',1784,2118,70,800,174);
INSERT INTO `nogoodspoint` VALUES (150,'038',1785,2119,159,1700,34);
INSERT INTO `nogoodspoint` VALUES (151,'038',1785,2120,159,1700,47);
INSERT INTO `nogoodspoint` VALUES (152,'0002',1786,2121,40,500,57);
INSERT INTO `nogoodspoint` VALUES (153,'0002',1750,2122,40,500,15);
INSERT INTO `nogoodspoint` VALUES (154,'0001',1787,2123,29,400,81);
INSERT INTO `nogoodspoint` VALUES (155,'0006',1788,2124,50,600,92);
INSERT INTO `nogoodspoint` VALUES (156,'0002',1789,2125,40,500,105);
INSERT INTO `nogoodspoint` VALUES (157,'035',1780,2126,130,1400,118);
INSERT INTO `nogoodspoint` VALUES (158,'032',1790,2127,100,1100,130);
INSERT INTO `nogoodspoint` VALUES (159,'034',1791,2128,119,1300,144);
INSERT INTO `nogoodspoint` VALUES (160,'036',1791,2129,280,3000,152);
INSERT INTO `nogoodspoint` VALUES (161,'0030',1792,2130,80,900,165);
INSERT INTO `nogoodspoint` VALUES (162,'0025',1760,2131,14,200,177);
INSERT INTO `nogoodspoint` VALUES (163,'035',1761,2132,130,1400,37);
INSERT INTO `nogoodspoint` VALUES (164,'036',1762,2133,140,1500,49);
INSERT INTO `nogoodspoint` VALUES (165,'031',1762,2134,90,1000,60);
INSERT INTO `nogoodspoint` VALUES (166,'078',1763,2135,20,300,72);
INSERT INTO `nogoodspoint` VALUES (167,'078',1764,2136,20,300,84);
INSERT INTO `nogoodspoint` VALUES (168,'032',1765,2137,200,2200,95);
INSERT INTO `nogoodspoint` VALUES (169,'078',1760,2138,20,300,108);
INSERT INTO `nogoodspoint` VALUES (170,'0006',1766,2139,50,600,121);
INSERT INTO `nogoodspoint` VALUES (171,'031',1767,2140,90,1000,133);
INSERT INTO `nogoodspoint` VALUES (194,'036',1777,2163,140,1500,77);
INSERT INTO `nogoodspoint` VALUES (195,'036',1805,2164,140,1500,88);
INSERT INTO `nogoodspoint` VALUES (197,'0002',1813,2166,40,500,100);
INSERT INTO `nogoodspoint` VALUES (198,'031',1806,2167,90,1000,113);
INSERT INTO `nogoodspoint` VALUES (199,'035',1806,2168,130,1400,125);
INSERT INTO `nogoodspoint` VALUES (200,'0002',1807,2169,40,500,139);
INSERT INTO `nogoodspoint` VALUES (201,'031',1583,2170,360,4000,7);
INSERT INTO `nogoodspoint` VALUES (202,'035',1821,2171,130,1400,161);
INSERT INTO `nogoodspoint` VALUES (203,'031',1821,2172,90,1000,172);
INSERT INTO `nogoodspoint` VALUES (205,'077',1566,2174,70,800,32);
INSERT INTO `nogoodspoint` VALUES (207,'077',1810,2176,70,800,45);
INSERT INTO `nogoodspoint` VALUES (208,'045',1811,2177,230,2400,55);
INSERT INTO `nogoodspoint` VALUES (209,'038',1808,2178,159,1700,69);
INSERT INTO `nogoodspoint` VALUES (210,'039',1812,2179,169,1800,79);
INSERT INTO `nogoodspoint` VALUES (213,'038',1814,2182,159,1700,90);
INSERT INTO `nogoodspoint` VALUES (214,'044',1815,2183,439,4600,103);
INSERT INTO `nogoodspoint` VALUES (215,'078',1816,2184,20,300,116);
INSERT INTO `nogoodspoint` VALUES (216,'033',1817,2185,109,1200,128);
INSERT INTO `nogoodspoint` VALUES (217,'041',1812,2186,189,2000,142);
INSERT INTO `nogoodspoint` VALUES (218,'031',1818,2187,90,1000,151);
INSERT INTO `nogoodspoint` VALUES (219,'0029',1753,2188,59,700,163);
INSERT INTO `nogoodspoint` VALUES (220,'077',1822,2189,70,800,175);
INSERT INTO `nogoodspoint` VALUES (221,'039',1823,2190,169,1800,35);
INSERT INTO `nogoodspoint` VALUES (222,'038',1815,2191,328,3500,48);
INSERT INTO `nogoodspoint` VALUES (223,'038',1815,2192,319,3400,58);
INSERT INTO `nogoodspoint` VALUES (224,'0030',1750,2193,80,900,16);
INSERT INTO `nogoodspoint` VALUES (225,'078',1824,2194,20,300,82);
INSERT INTO `nogoodspoint` VALUES (226,'078',1766,2195,20,300,93);
INSERT INTO `nogoodspoint` VALUES (227,'077',1825,2196,70,800,106);
INSERT INTO `nogoodspoint` VALUES (228,'0006',1826,2197,50,600,119);
INSERT INTO `nogoodspoint` VALUES (229,'0006',1827,2198,50,600,131);
INSERT INTO `nogoodspoint` VALUES (230,'0002',1753,2199,40,500,145);
INSERT INTO `nogoodspoint` VALUES (231,'033',1828,2200,109,1200,153);
INSERT INTO `nogoodspoint` VALUES (232,'0001',1829,2201,29,400,166);
INSERT INTO `nogoodspoint` VALUES (233,'0006',1830,2202,50,600,178);
INSERT INTO `nogoodspoint` VALUES (234,'0006',1831,2203,50,600,38);
INSERT INTO `nogoodspoint` VALUES (235,'033',1832,2204,109,1200,50);
INSERT INTO `nogoodspoint` VALUES (236,'0023',1833,2205,9,100,61);
INSERT INTO `nogoodspoint` VALUES (237,'032',1834,2206,100,1100,73);
INSERT INTO `nogoodspoint` VALUES (238,'077',1835,2207,70,800,85);
INSERT INTO `nogoodspoint` VALUES (239,'042',1815,2208,200,2100,96);
INSERT INTO `nogoodspoint` VALUES (240,'0006',1836,2209,50,600,109);
INSERT INTO `nogoodspoint` VALUES (241,'039',1777,2210,169,1800,122);
INSERT INTO `nogoodspoint` VALUES (242,'031',1778,2211,90,1000,134);
INSERT INTO `nogoodspoint` VALUES (243,'0029',1665,2212,59,700,4);
INSERT INTO `nogoodspoint` VALUES (244,'0023',1837,2213,9,100,156);
INSERT INTO `nogoodspoint` VALUES (245,'035',1838,2214,130,1400,169);
INSERT INTO `nogoodspoint` VALUES (246,'042',1812,2215,200,2100,27);
INSERT INTO `nogoodspoint` VALUES (247,'041',1657,2216,189,2000,2);
INSERT INTO `nogoodspoint` VALUES (248,'0002',1839,2217,40,500,53);
INSERT INTO `nogoodspoint` VALUES (249,'077',1840,2218,70,800,64);
INSERT INTO `nogoodspoint` VALUES (250,'0025',1841,2219,14,200,76);
INSERT INTO `nogoodspoint` VALUES (251,'041',1812,2220,379,4000,87);
INSERT INTO `nogoodspoint` VALUES (252,'036',1842,2221,140,1500,99);
INSERT INTO `nogoodspoint` VALUES (253,'038',1843,2222,159,1700,112);
INSERT INTO `nogoodspoint` VALUES (254,'0030',1844,2223,80,900,124);
INSERT INTO `nogoodspoint` VALUES (255,'037',1845,2224,150,1600,137);
INSERT INTO `nogoodspoint` VALUES (256,'038',1846,2225,319,3400,148);
INSERT INTO `nogoodspoint` VALUES (257,'0030',1847,2226,80,900,159);
INSERT INTO `nogoodspoint` VALUES (258,'035',1721,2227,130,1400,24);
INSERT INTO `nogoodspoint` VALUES (259,'037',1848,2228,150,1600,30);
INSERT INTO `nogoodspoint` VALUES (260,'0006',1849,2229,50,600,43);
INSERT INTO `nogoodspoint` VALUES (261,'0029',1850,2230,59,700,54);
INSERT INTO `nogoodspoint` VALUES (262,'034',1851,2231,119,1300,67);
INSERT INTO `nogoodspoint` VALUES (263,'038',1852,2232,159,1700,78);
INSERT INTO `nogoodspoint` VALUES (264,'0006',1853,2233,50,600,89);
INSERT INTO `nogoodspoint` VALUES (265,'0006',1854,2234,50,600,101);
INSERT INTO `nogoodspoint` VALUES (266,'042',1855,2235,200,2100,114);
INSERT INTO `nogoodspoint` VALUES (267,'035',1856,2236,130,1400,126);
INSERT INTO `nogoodspoint` VALUES (268,'032',1857,2237,100,1100,140);
INSERT INTO `nogoodspoint` VALUES (269,'0001',1858,2238,29,400,149);
INSERT INTO `nogoodspoint` VALUES (270,'0002',1750,2239,40,500,19);
INSERT INTO `nogoodspoint` VALUES (271,'0025',1859,2240,14,200,173);
INSERT INTO `nogoodspoint` VALUES (272,'0025',1753,2241,14,200,33);
INSERT INTO `nogoodspoint` VALUES (273,'078',1860,2242,20,300,46);
INSERT INTO `nogoodspoint` VALUES (274,'041',1812,2243,189,2000,56);
INSERT INTO `nogoodspoint` VALUES (275,'031',1861,2244,90,1000,70);
INSERT INTO `nogoodspoint` VALUES (277,'045',1782,2246,230,2400,80);
INSERT INTO `nogoodspoint` VALUES (278,'036',1862,2247,140,1500,91);
INSERT INTO `nogoodspoint` VALUES (279,'0029',1856,2248,59,700,104);
INSERT INTO `nogoodspoint` VALUES (280,'0002',1863,2249,40,500,117);
INSERT INTO `nogoodspoint` VALUES (281,'044',1818,2250,219,2300,129);
INSERT INTO `nogoodspoint` VALUES (282,'0002',1864,2251,40,500,143);
INSERT INTO `nogoodspoint` VALUES (283,'043',1746,2252,210,2200,8);
INSERT INTO `nogoodspoint` VALUES (284,'043',1856,2253,210,2200,164);
INSERT INTO `nogoodspoint` VALUES (286,'042',1815,2255,200,2100,176);
INSERT INTO `nogoodspoint` VALUES (287,'033',1867,2256,109,1200,36);
INSERT INTO `nogoodspoint` VALUES (288,'0002',1750,2257,40,500,12);
INSERT INTO `nogoodspoint` VALUES (289,'0029',1858,2258,59,700,59);
INSERT INTO `nogoodspoint` VALUES (290,'0001',1753,2259,29,400,71);
INSERT INTO `nogoodspoint` VALUES (291,'0025',1868,2260,14,200,83);
INSERT INTO `nogoodspoint` VALUES (294,'052',1849,2263,200,1550,94);
INSERT INTO `nogoodspoint` VALUES (295,'052',1849,2263,200,1550,107);
INSERT INTO `nogoodspoint` VALUES (296,'0002',1869,2264,40,500,120);
INSERT INTO `nogoodspoint` VALUES (297,'061',1870,2265,194,2000,132);
INSERT INTO `nogoodspoint` VALUES (298,'061',1870,2265,194,2000,146);
INSERT INTO `nogoodspoint` VALUES (299,'042',1871,2266,200,2100,154);
INSERT INTO `nogoodspoint` VALUES (300,'0002',1872,2267,40,500,167);
INSERT INTO `nogoodspoint` VALUES (301,'0030',1799,2268,80,900,179);
INSERT INTO `nogoodspoint` VALUES (302,'031',1873,2269,90,1000,39);
INSERT INTO `nogoodspoint` VALUES (303,'031',1873,2270,90,1000,51);
INSERT INTO `nogoodspoint` VALUES (304,'0001',1874,2271,29,400,62);
贴建表及插入记录的SQL
DROP TABLE IF EXISTS `tbl_loop`;
CREATE TABLE `tbl_loop` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`loopNumber` int(11) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk;#
# Dumping data for table tbl_loop
#LOCK TABLES `tbl_loop` WRITE;
/*!40000 ALTER TABLE `tbl_loop` DISABLE KEYS */;
INSERT INTO `tbl_loop` VALUES (1,5);
/*!40000 ALTER TABLE `tbl_loop` ENABLE KEYS */;
UNLOCK TABLES;
在里面呢。
贴建表及插入记录的SQL1次性将所有用到的表贴出来
能否通过
INSERT INTO `memberinfo` VALUES (1832,NULL,'15246658896','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:32:36',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1833,NULL,'15045429458','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:33:15',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1834,NULL,'18249749767','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:33:55',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1835,NULL,'15045422227','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:34:34',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1836,NULL,'156634466341','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:35:56',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1837,NULL,'13936613735','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:36:35',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1838,NULL,'15946050951','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:37:12',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1839,NULL,'13644506058','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:37:55',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1840,NULL,'13766763926','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:38:37',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1841,NULL,'15145191664','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:39:15',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1842,NULL,'13613625588','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:39:52',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1843,NULL,'13313691990','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:40:27',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1844,NULL,'13115550581','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:41:08',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1845,NULL,'13089715209','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:41:59',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1846,NULL,'13796813738','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:42:36',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1847,NULL,'13009873651','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:43:13',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1848,NULL,'86079639','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:44:10',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1849,NULL,'18745794512','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:44:46',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1850,NULL,'1355339777','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:45:23',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1851,NULL,'15114680731','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:45:55',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1852,NULL,'13895813808','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:46:34',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1853,NULL,'15546162996','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:47:04',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1854,NULL,'13945175155','男',NULL,'[email protected]',NULL,1,'2011-05-14 16:47:45',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1855,NULL,'18775564777','男',NULL,'[email protected]',NULL,1,'2011-05-15 14:21:41',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1856,NULL,'13766819092','男',NULL,'[email protected]',NULL,1,'2011-05-15 14:22:24',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1857,NULL,'13704588949','男',NULL,'[email protected]',NULL,1,'2011-05-15 14:23:01',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1858,NULL,'13578619556','男',NULL,'[email protected]',NULL,1,'2011-05-15 14:23:38',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1859,NULL,'18715691876','男',NULL,'[email protected]',NULL,1,'2011-05-15 14:24:24',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1860,NULL,'15846814732','男',NULL,'[email protected]',NULL,1,'2011-05-15 14:25:00',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1861,NULL,'8113399','男',NULL,'[email protected]',NULL,1,'2011-05-15 14:25:42',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1862,NULL,'18618127869','男',NULL,'[email protected]',NULL,1,'2011-05-15 14:26:20',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1863,NULL,'13936167161','男',NULL,'[email protected]',NULL,1,'2011-05-15 14:26:59',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1864,NULL,'13728944566','男',NULL,'[email protected]',NULL,1,'2011-05-16 14:54:53',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1865,NULL,'13658652013','男',NULL,'[email protected]',NULL,1,'2011-05-16 14:56:27',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1866,NULL,'13946021742','男',NULL,'[email protected]',NULL,1,'2011-05-16 14:59:05',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1867,NULL,'15846362321','男',NULL,'[email protected]',NULL,1,'2011-05-16 14:59:56',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1868,NULL,'15669803792','男',NULL,'[email protected]',NULL,1,'2011-05-16 15:00:31',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1869,NULL,'13361930773','男',NULL,'[email protected]',NULL,1,'2011-05-18 17:06:00',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1870,NULL,'15044486859','男',NULL,'[email protected]',NULL,1,'2011-05-18 17:10:11',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1871,NULL,'13694509876','男',NULL,'[email protected]',NULL,1,'2011-05-18 17:10:50',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1872,NULL,'13503634867','男',NULL,'[email protected]',NULL,1,'2011-05-18 17:13:55',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1873,NULL,'13009704645','男',NULL,'[email protected]',NULL,1,'2011-05-18 17:14:58',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1874,NULL,'15145342916','男',NULL,'[email protected]',NULL,1,'2011-05-19 15:02:20',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1875,NULL,'13633692714','男',NULL,'[email protected]',NULL,1,'2011-05-19 15:03:01',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1876,NULL,'13089993977','男',NULL,'[email protected]',NULL,1,'2011-05-19 15:03:42',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1877,NULL,'15204676606','男',NULL,'[email protected]',NULL,1,'2011-05-19 15:04:26',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1878,NULL,'15104596043','男',NULL,'[email protected]',NULL,1,'2011-05-19 15:05:02',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1879,NULL,'15046776783','男',NULL,'[email protected]',NULL,1,'2011-05-19 15:06:03',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1880,NULL,'15245164503','男',NULL,'[email protected]',NULL,1,'2011-05-19 15:06:48',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1881,NULL,'13704841296','男',NULL,'[email protected]',NULL,1,'2011-05-19 15:07:37',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1882,NULL,'15244663121','男',NULL,'[email protected]',NULL,1,'2011-05-19 15:08:10',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1883,NULL,'15245163651','男',NULL,'[email protected]',NULL,1,'2011-05-19 15:08:42',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);
INSERT INTO `memberinfo` VALUES (1884,NULL,'13936384819','男',NULL,'[email protected]',NULL,1,'2011-05-19 15:09:24',0,0,0,0,NULL,0,0,'230111',11,NULL,NULL);