如何在mysql中使用select语句插入值？ [英] How do I insert a value using select statement in mysql ?

问题描述

我有以下SQL命令：

I have the following SQL command:

select COLUMN_NAME
FROM
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
      REFERENCED_TABLE_NAME  = 'persons_data'
  AND REFERENCED_COLUMN_NAME = 'ID'
  AND TABLE_NAME             = 'employees'

这将返回外键子表员工即 persons_data_ID 。我的问题是我想在那个外键字段中插入一个值，以说明我需要的东西，我将展示我尝试过的东西。



我尝试了什么：

This returns the foreign key in the child table employees that is persons_data_ID. My problem is I want to insert a value in that foreign Key field, to illustrate what i need I will show what I tried.

What I have tried:

INSERT INTO `mySchema`.`persons_data` (`Name En`, `Address`, `National ID`) 
VALUES 
('Noud', 'Tyjkl', '697851');

INSERT INTO `mySchema`.`employees` 
(select COLUMN_NAME
FROM
  INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
      REFERENCED_TABLE_NAME  = 'persons_data'
  AND REFERENCED_COLUMN_NAME = 'ID'
  AND TABLE_NAME             = 'employees') 
VALUES ( LAST_INSERT_ID());

我希望以前的代码能够运行喜欢下面这个，但我不想知道我做了什么错误？

I expect the previous code to function like the following one but it did not i want to know what is the mistake i did?

INSERT INTO `mySchema`.`persons_data` (`Name En`, `Address`, `National ID`) 
VALUES 
('Noud', 'Tyjkl', '697851');

INSERT INTO `mySchema`.`employees` 
(persons_data_ID) 
VALUES ( LAST_INSERT_ID());

推荐答案

模式名称不匹配。



您是否正在尝试破解药房数据库？看起来像。这是非法的。

The schema names don't match.

Are you trying to hack a Pharmacy database? Looks like it. That's illegal.

这篇关于如何在mysql中使用select语句插入值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！