MYSQL INSERT SELECT问题 [英] MYSQL INSERT SELECT problem

问题描述

我在理解如何执行一些INSERT SELECT方面有些困难.

i have a little difficulty in understanding how to do some INSERT SELECT.

例如，我有两个表.

TABLE : users  

 id | name   | gender  
 1  | John   | m  
 2  | Mary   | f  

TABLE : website  

 fid | url             | id  
 1   | www.desilva.biz | 2  
 2   | gidhelp.com     | 4  

现在让我们说我想向表网站添加另一个查询.我得到两个变量，可以说:

Now let's say i want to add another query to the table website. I get two variables, lets say:

$user = John;
$site = "www.google.com";

我想从用户表中选择John的ID，然后在一条语句中将其插入网站表中.

i want to select the id of John from users table and insert it into website table in one statement.

我该怎么办?

推荐答案

假定您的变量已经正确转义并且不受SQL注入的限制:

Assuming your variables are already escaped properly and are not subject to SQL injection:

INSERT
INTO    website (url, fid)
SELECT  $site, id
FROM    users
WHERE   name = $user

这篇关于MYSQL INSERT SELECT问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！