sql-在一个查询中插入多个表 [英] sql - insert into multiple tables in one query

问题描述

假设我有两个表，names和phones 我想在一个查询中将来自某些输入的数据插入表中，该怎么办?

assuming that i have two tables, names and phones and i want to insert data from some input to the tables, in one query- How can it be done?

如果可以的话，请解释其语法.

Please, if it can be done, explain the syntax.

推荐答案

MySQL不支持在单个

MySQL doesn't support multi-table insertion in a single INSERT statement. Oracle is the only one I'm aware of that does, oddly...

INSERT INTO NAMES VALUES(...)
INSERT INTO PHONES VALUES(...)

这篇关于sql-在一个查询中插入多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！