SQL Select inside Insert

Ikon · #1 (**permalink**) 09-09-2008

I have following.

Code:

.
.
.
$userid = 2
.
$query = "select username from users where userid = ".$userid.";";
.
$username = $line['uid'];
$data="Some Data Here";
.
$query = "insert into logger (username, data) valuse ($username, $data);";
.

I would like to not have 2 database calls.

Im sure there is a way to "join" the 2. I want to store the actual username in the logger table and not the UID#, I have not had much luck.

Probabally something really easy im missing.

Something like this:

Code:

insert into logging 
('type','who','data','ipaddress') 
values 
("testing", (select username from users where id = 2;), "data here","1.1.1.1");

Thanks...

Ikon · #2 (**permalink**) 09-09-2008

I figured it out...

Code:

insert into logging 
(type,who,data,ipaddress) 
values 
("testing",(select username from users where id = 2),"data here","1.1.1.1");

Was using wrong quotes.

cbkihong · #3 (**permalink**) 09-11-2008

In MySQL there is a INSERT ... SELECT that you can probably use to avoid a subquery, but you didn't confirm whether you were using MySQL. Not sure about other database engines though.

Ikon · #4 (**permalink**) 09-11-2008

Yes I am using MySQL v5.0.45

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
select function	nagalenoj	High Level Programming	0	06-10-2008 06:42 AM
Supress ' quotes in a select statement inside Shell Script	mahabunta	Shell Programming and Scripting	1	12-14-2006 06:29 PM
Select ALL in VI Editor	rakish	UNIX for Dummies Questions & Answers	22	08-14-2006 06:51 AM
looping a array inside inside ssh is not working, pls help	reldb	Shell Programming and Scripting	5	07-07-2006 11:32 AM
how to select a value randomly	norsk hedensk	Shell Programming and Scripting	1	10-28-2003 05:39 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by