每当insert到一个月的月末比如2006-05-31之后就全都变成0000-00-00,一直进入死循环了怎么破啊???
下面是代码,min是起始日期,max是结束日期,tmp是要插入的表格,里面有三个字段,第二个就是要连续插入的日期。begin
declare v date;
declare max date;
declare min date;
set max = (select max(cast(datetime as date)) from comment WHERE shop=1894891);
set min = (select min(cast(datetime as date)) from comment WHERE shop=1894891);
set v = min;
insert into tmp values (null, min, 0, 0);
insert into tmp values (null, max, 0, 0);
repeat
insert into tmp values (null,v,0,0);
set v = v + 1;
until v >= max
end repeat;
end
下面是代码,min是起始日期,max是结束日期,tmp是要插入的表格,里面有三个字段,第二个就是要连续插入的日期。begin
declare v date;
declare max date;
declare min date;
set max = (select max(cast(datetime as date)) from comment WHERE shop=1894891);
set min = (select min(cast(datetime as date)) from comment WHERE shop=1894891);
set v = min;
insert into tmp values (null, min, 0, 0);
insert into tmp values (null, max, 0, 0);
repeat
insert into tmp values (null,v,0,0);
set v = v + 1;
until v >= max
end repeat;
end
解决方案 »
- ACMAIN_CHM,刚才那问题续
- 又一新的中文乱码问题
- mysql源码windows版的在哪?
- 设了主键 却能设为空 如何理解和解决?
- 新手100分求助:多个表的多字段复制(各字段相互有关联!)到其他的表中去怎么写SQL语句没思路
- 为何我从msSQL7里面将数据导入到mySQL5后,中文变成了乱码
- 请问MYSQL4.0表的大小有限制吗?3.23限制是4G是吗?
- delphi中的mysql的连接问题
- 请问我这个MYSQL错误怎么解决?
- 求助下:一个表中用了5、6个blob类型的字段存放的是图片流,查询的时候很慢,如何优化
- MYSQL 关于一次性给多个变量赋值问题;
- W2k下服务器程序和客户机程序能否共存???
其中列出了MySQL中存储过程实现方式,核心是循环加上
insert into date_intervals values(thisDate);
set thisDate=thisDate + interval 1 day;
BEGIN
DECLARE ps_count INT DEFAULT 0;
WHILE ps_count < 85
DO
SET @theTime = date_add('2013-06-15', INTERVAL ps_count DAY);
INSERT INTO `isa_pbxx` (`jgm`, `gtid`, `gybh`, `gyxm`, `dqrq`, `pbbz`, `qrsj`, `qcsj`) VALUES
('22222', '1', '88801', '张无忌', @theTime, NULL, concat(@theTime,' 08:00:00'), concat(@theTime,' 18:00:00')) ,
('22299', '31', '99922', '梅超风', @theTime, NULL, concat(@theTime, ' 08:00:00'), concat(@theTime, ' 18:00:00'));
SET ps_count = ps_count + 1;
END WHILE;
END