MYSQL INSERT SELECT problem

Question

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

For instance i have two tables.

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";

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

How can i do it?

Quassnoi · Accepted Answer · 2009-09-07 15:05:43Z

8

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

edited Sep 7, 2009 at 15:05

answered Sep 7, 2009 at 11:57

Quassnoi

427k94 gold badges628 silver badges623 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Adriano Varoli Piazza Over a year ago

I'd quote at least $user so that it matched correctly on names that contain spaces.

Collectives™ on Stack Overflow

MYSQL INSERT SELECT problem

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related