(SELECT meetingtype AS title, meetingstime AS stime, meetingetime AS etime FROM t_cardcontent762) UNION ALL (SELECT ggwork AS title, ggstime AS stime, ggetime AS etime FROM t_cardcontent763 LIMIT 0 , 30 )
插入临时表 insert into lsb SELECT meetingtype AS title, meetingstime AS stime, meetingetime AS etime FROM t_cardcontent762 insert into lsb SELECT ggwork AS title, ggstime AS stime, ggetime AS etime FROM t_cardcontent763
7楼的意思是对的(SELECT meetingtype AS title, meetingstime AS stime, meetingetime AS etime FROM t_cardcontent762) UNION ALL (SELECT ggwork AS title, ggstime AS stime, ggetime AS etime FROM t_cardcontent763)最基本的语法,楼主玩的太野了。
UNION ALL
(SELECT ggwork AS title, ggstime AS stime, ggetime AS etime FROM t_cardcontent763 LIMIT 0 , 30 )
insert into lsb SELECT meetingtype AS title, meetingstime AS stime, meetingetime AS etime FROM t_cardcontent762
insert into lsb SELECT ggwork AS title, ggstime AS stime, ggetime AS etime FROM t_cardcontent763
UNION ALL
(SELECT ggwork AS title, ggstime AS stime, ggetime AS etime FROM t_cardcontent763)最基本的语法,楼主玩的太野了。