首頁(yè) 猿問(wèn) MYSQL數(shù)據(jù)庫(kù)，inser...

MYSQL數(shù)據(jù)庫(kù)，inser into select where 語(yǔ)句

MySQL

眼眸繁星 2019-04-09 05:04:29

MYSQL 數(shù)據(jù)庫(kù)，同一個(gè)數(shù)據(jù)庫(kù)中有兩個(gè)表 news和article，現(xiàn)在我想把表article中的字段 title content zznews nfrom hits dateandtime editor 內(nèi)的值賦值給表news中的字段 title content author source hits sendtime keywords，SQL語(yǔ)句該怎么寫(xiě)？我之前像下面那么寫(xiě)的，出錯(cuò)，請(qǐng)高手來(lái)解答！insert into news(Title,Content,Author,Source,Hits,Sendtime,Keywords) values select title,content,zznews,nfrom,hits,dateandtime,editor from article where tjnews=0 and typeid=8

查看完整描述

2 回答

弒天下

TA貢獻(xiàn)1818條經(jīng)驗(yàn) 獲得超8個(gè)贊

你的字段都沒(méi)搞出來(lái),怎么啊,我假如你只有三個(gè)字段,一個(gè)ID,一個(gè)column1,column2吧:
Delete From table
where ID not in (Select min(iD) From Table group by column1,column2)
--有多少個(gè)字段,group by 后面加多少個(gè),ID除外

反對(duì) 回復(fù) 2019-04-10

開(kāi)滿天機(jī)

TA貢獻(xiàn)1786條經(jīng)驗(yàn) 獲得超13個(gè)贊

insert into news(Title,Content,Author,Source,Hits,Sendtime,Keywords) select title,content,zznews,nfrom,hits,dateandtime,editor from article where tjnews=0 and typeid=8

反對(duì) 回復(fù) 2019-04-10