这样以张表
create table result
(
id varchar(20) primary key not null,
clientname varchar(40),
visit varchar(40),
aimTurnover varchar(40),
turnover varchar(40),
state varchar(20),
aimObjectTask varchar(40),
objectTask varchar(40),
aimRestTask varchar(40),
restTask varchar(40),
re varchar(80),
accessTime datetime,
aimSort varchar(20),
seller varchar(40),
party varchar(40),
mouth varchar(40),
year varchar(40)
);
我想在每个月1号 将上个月的某些信息(例如aimTurnover,aimObjectTask,等)在插入一遍,作为本月的信息,该怎么做
create table result
(
id varchar(20) primary key not null,
clientname varchar(40),
visit varchar(40),
aimTurnover varchar(40),
turnover varchar(40),
state varchar(20),
aimObjectTask varchar(40),
objectTask varchar(40),
aimRestTask varchar(40),
restTask varchar(40),
re varchar(80),
accessTime datetime,
aimSort varchar(20),
seller varchar(40),
party varchar(40),
mouth varchar(40),
year varchar(40)
);
我想在每个月1号 将上个月的某些信息(例如aimTurnover,aimObjectTask,等)在插入一遍,作为本月的信息,该怎么做
select id+10000,clientname,visit,aimTurnover,turnover,state,aimObjectTask,objectTask,aimRestTask,restTask,re,accessTime,aimSort,seller,party,'FEB','2009'
from `result`
where mouth='JAN' and year='2009'建议把 id 改成auto_increament, month, year改为数字型或日期型
select curdate(),* from `result` where year=2009 and mouth=
month(mouth)-1
我是想在登陆的时候检测下日期是1号 就执行SQL语句
select id+10000,clientname,visit,aimTurnover,turnover,state,aimObjectTask,objectTask,aimRestTask,restTask,re,accessTime,aimSort,seller,party,'FEB','2009'
from `result` a
where mouth='JAN' and year='2009'
and not exists (select 1 from `result` where mouth='FEB' and year='2009' and clientname =a.clientname)
A.aimSort,A.seller,'2009','04' FROM result A
LEFT JOIN result B
ON A.seller=B.seller AND A.year=2009 AND A.month=03
WHERE B.SELLER IS NULL