请教一查询插入语句

INSERT news(adv_memberid,news_topic,content,announce_time,last_time,type)
select 'admin', news_topic、content、time, time, type
from other_news
where ...

解决方案 »

  1.   

    insert into news(adv_memberid,new_topic,content,announce_time,last_time,type)
    select 'admin',
           other_news.news_topic,
           other_news.content,
           other_news.type,
           other_news.time,
           other_news.time,
           other_news.type
      

  2.   

    insert into news(adv_memberid,news_topic,content,announce_time,last_time,type)
    select 'admin',news_topic,content,time,time,type
    from other_news
      

  3.   

    如下试试INSERT news(adv_memberid,news_topic,content,announce_time,last_time,type)
    select 'admin', news_topic,content,time, time, type
    from other_news
      

  4.   

    insert into news(adv_memberid,new_topic,content,announce_time,last_time,type)
    select 'admin',
           other_news.news_topic,
           other_news.content,
           other_news.type,
           other_news.time,
           other_news.time,
           other_news.type
    from othernews --刚才这里少写了