Re: long select query result as as query string on another select statment

Hi, ok i got it working. it was a typo(lol), i missed from in the initial select statment Wrong ### select * db_users where db_id=(SELECT id FROM data_bases where dom_id=(SELECT id FROM domains where name='abc.com')); Correct ## select * from db_users where db_

Re: long select query result as as query string on another select statment

-- > > --- > > (SELECT id FROM domains where name='abc.com'); > > gives a result of 124 > > > i am also able to use and get proper results for the following query: > > select * from domains where id=(SELECT id FROM domains where name='abc.com > '); >

Re: long select query result as as query string on another select statment

what is the issue ur facing. Any syntax error or something else. trying usin "IN" instead of "=" On 9/26/08, Madan Thapa <[EMAIL PROTECTED]> wrote: > > Hi, > > > - > > (SELECT id FROM domains where name='abc.com'); > > gives a result of 124 > >

long select query result as as query string on another select statment

Hi, - (SELECT id FROM domains where name='abc.com'); gives a result of 124 i am also able to use and get proper results for the following query: select * from domains where id=(SELECT id FROM domains where name='abc.com '); --

Re: Can I use the information from "SHOW STATUS" in a SELECT statment ?

Speaking of Perl scripts that do this: http://codenode.com/mysqlreport I almost never use SHOW STATUS directly anymore since most the values have to be transformed one way or another to really be meaningful. -Daniel Sid Lane wrote: I don't know if you can do it directly in a mysql shell like t

RE: Can I use the information from "SHOW STATUS" in a SELECT statment ?

> -Original Message- > From: Sid Lane [mailto:[EMAIL PROTECTED] > Sent: 16 August 2005 14:54 > To: mysql@lists.mysql.com > Subject: Re: Can I use the information from "SHOW STATUS" in > a SELECT statment ? > > I don't know if you can do it direc

Re: Can I use the information from "SHOW STATUS" in a SELECT statment ?

I don't know if you can do it directly in a mysql shell like that (like you would with v$, dba_ in Oracle) but if you call a show command from PERL (via DBI) it hashes the result just like it were from a select. may not be the most elegant solution but its the best I've come up with though I'll ha

Can I use the information from "SHOW STATUS" in a SELECT statment ?

Hello to everyone on [EMAIL PROTECTED], In 2 words, what I wish to do is something like : mysql> SELECT @@Qcache_queries_in_cache / @@Qcache_hits; Is it possible ? Thank you. -- Cheers, Maxim Vexler (hq4ever). Do u GNU ? -- MySQL General Mailing List For list archives: http://lists.mysql.

Re: Select Statment Question

| | cc: | | Sub

Select Statment Question

Hi, I have to search a big database. Now there are many categories i.e computerlanguage = C++, Perl,Php,Visual Basic, C, Javascript. In my table C++ =1 Perl = 2 PhP = 3 VB = 4 C = 5 Java = 6 and i have a select statment like this SELECT * FROM lang WHERE language = 1 OR language = 2 OR language

FW: Select statment

John, StudioName? GenreName? F_Name? L_Name? DatabaseName? ServerName? Alan I can't seem to figure out the select statement to get the name. Do I need the the StarID or ActorID in Titles table? Thank you. I am using PHP and MYSQL. Studios (StudioName, StudioID) Genres (GenreName, GenreID) Tit

Select statment

I can't seem to figure out the select statement to get the name. Do I need the the StarID or ActorID in Titles table? Thank you. I am using PHP and MYSQL. Studios (StudioName, StudioID) Genres (GenreName, GenreID) Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) Actors (F_Nam