mysql insert into select 后面还可以跟上values么

Question

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()

Answer 1

INSERT INTO BLOCKMANAGE(BMUID,FORUMID,BMTYPE,MUID,MTIME) VALUES((SELECT UID FROM MEMBER WHERE UID=0 OR MEMBERNAME='admin'),
2010082715484700,
0,
0,
getdate());