MySQL插入和加盟 [英] MySQL Insert & Joins

问题描述

我看到了

在MySQL中，加入INSERT的工作， UPDATE和DELETE语句.它是 可能在以下范围内更改数据 在一个表中加入一个表时 UPDATE或DELETE语句.

In MySQL, joins work for INSERT, UPDATE, and DELETE statements. It's possible to change data in more than one table when joining tables in an UPDATE or DELETE statement.

在mysql认证指南中对问题的回答.是真的吗插入连接?一个例子吗?

in an answer for a question from the mysql certification guide. is it true? inserts with joins? an example of it?

推荐答案

您可以使用mysql插入... SELECT，这可能就是他们的意思.例如:

You can INSERT ... SELECT with mysql, which is probably what they mean. For example:

INSERT INTO tableNew (col1, col2)
  SELECT tbl1.col1, tbl2.col2
  FROM tbl1 JOIN tbl2

这篇关于MySQL插入和加盟的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！