mysql->插入tbl(从另一个表中选择)和一些默认值 [英] mysql -> insert into tbl (select from another table) and some default values

问题描述

正如标题所说，我试图插入一个表，从另一个表中选择值和一些默认值.

As the title says, I am trying to insert into one table selecting values from another table and some default values.

INSERT INTO def (catid, title, page, publish) 
(SELECT catid, title from abc),'page','yes')


INSERT INTO def (catid, title, page, publish) 
VALUES
((SELECT catid, title from abc),'page','yes'))

第一个查询给出mysql错误，第二个查询给出列数不匹配.

The first query gives a mysql error and the second one gives column count does not match.

我需要做什么?

推荐答案

您只需要做:

INSERT INTO def (catid, title, page, publish) 
SELECT catid, title, 'page','yes' from `abc`

这篇关于mysql->插入tbl(从另一个表中选择)和一些默认值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！