mysql insert into select 后面还可以跟上values么,类似这样的
INSERT INTO BLOCKMANAGE(BMUID,FORUMID,BMTYPE,MUID,MTIME) SELECT UID FROM MEMBER WHERE UID=0 OR MEMBERNAME='admin',
2010082715484700,
0,
0,
getdate()
INSERT INTO BLOCKMANAGE(BMUID,FORUMID,BMTYPE,MUID,MTIME) VALUES((SELECT UID FROM MEMBER WHERE UID=0 OR MEMBERNAME='admin'),
2010082715484700,
0,
0,
getdate());
INSERT INTO BLOCKMANAGE(BMUID,FORUMID,BMTYPE,MUID,MTIME) VALUES((SELECT UID FROM MEMBER WHERE UID=0 OR MEMBERNAME='admin'),
2010082715484700,
0,
0,
getdate()); 上楼正解
INSERT INTO BLOCKMANAGE(BMUID,FORUMID,BMTYPE,MUID,MTIME) VALUES((SELECT UID FROM MEMBER WHERE UID=0 OR MEMBERNAME='admin'),
2010082715484700,
0,
0,
getdate());
是不是oracle可以直接安装楼主上面的写。mysql我就不太清楚了。