update tb1 a,tb2 b set a.xx=b.xx where a.id=b.id-6;
DELETE * FROM table1 WHERE cols-date="2014-08-02"; INSERT INTO table1 (cols1,cols2,cols3,cols4,cols-date) VALUES (SELECT cols1,cols2,cols3,cols4,"2014-08-02" FROM table1 WHERE cols-date="2014-08-01"); 你试试吧
DELETE * FROM table1 WHERE cols-date="2014-08-02"; INSERT INTO table1 (cols1,cols2,cols3,cols4,cols-date) (SELECT cols1,cols2,cols3,cols4,cols-date FROM table1 WHERE cols-date="2014-08-01"); 刚才写错了,看看这条
我打个比方,你自己对比着做 INSERT INTO table1 (cols1,cols2,cols3,cols4,cols-date) (SELECT cols1,cols2,cols3,cols4,"2014-08-05" FROM table1 WHERE cols-date IN ("2014-08-02","2014-08-03","2014-08-04"));
INSERT INTO table1 (cols1,cols2,cols3,cols4,cols-date) VALUES (SELECT cols1,cols2,cols3,cols4,"2014-08-02" FROM table1 WHERE cols-date="2014-08-01");
你试试吧
INSERT INTO table1 (cols1,cols2,cols3,cols4,cols-date) (SELECT cols1,cols2,cols3,cols4,cols-date FROM table1 WHERE cols-date="2014-08-01");
刚才写错了,看看这条
参考一下这个贴子的提问方式http://bbs.csdn.net/topics/320211382
1. 你的 create table xxx .. 语句
2. 你的 insert into xxx ... 语句
3. 结果是什么样,(并给以简单的算法描述)
4. 你用的数据库名称和版本(经常有人在MS SQL server版问 MySQL)
这样想帮你的人可以直接搭建和你相同的环境,并在给出方案前进行测试,避免文字描述理解上的误差。
INSERT INTO table1 (cols1,cols2,cols3,cols4,cols-date)
(SELECT cols1,cols2,cols3,cols4,"2014-08-05" FROM table1
WHERE cols-date IN ("2014-08-02","2014-08-03","2014-08-04"));