Re: [PHP] A mysql question...

On 21 October 2010 14:13, Midhun Girish wrote: > | Name | phone |userid| > > ++--+--+ > > | Mr Sasi | 01225 708225 | 1 | > > | Miss Brown | 01225 899360 | 2 | > > | Mr Black | 01380 724040 | 3 | > > ++--+--+ > Table B > > ++--

[PHP] A mysql question...

hai all, I have two tables a and b as follows to implement a simple block list where users can block other users. Table A ++--+--+ | Name | phone |userid| ++--+--+ | Mr Sasi | 01225 708225 | 1 | | Miss Brown | 01225 899360 | 2 | | M

Re: [PHP] A MySQL Question

> Sure you can... I'm screaming right now... and I'm in space. A container > within a container within a container within a container (ad infinitum) > is still within the outermost container. I didn't hear you scream. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http:

Re: [PHP] A MySQL Question

On Tue, 2008-12-09 at 01:49 -0800, Yeti wrote: > As a matter of fact, in space you can't even scream. Sure you can... I'm screaming right now... and I'm in space. A container within a container within a container within a container (ad infinitum) is still within the outermost container. Cheers, R

Re: [PHP] A MySQL Question

On Tue, 2008-12-09 at 16:40 +, [EMAIL PROTECTED] wrote: > Perhaps you couldn't hear the big bang in this universe, but what about in > the universe that spawned it? > :-) The black hole wouldn't allow it to travel in that direction ;) Cheers, Rob. -- http://www.interjinn.com Application and

Re: [PHP] A MySQL Question

On Tue, Dec 9, 2008 at 11:40 AM, <[EMAIL PROTECTED]> wrote: > > Perhaps you couldn't hear the big bang in this universe, but what about in > the universe that spawned it? > :-) > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > The o

Re: [PHP] A MySQL Question

Perhaps you couldn't hear the big bang in this universe, but what about in the universe that spawned it? :-) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] A MySQL Question

At 12:44 AM +1300 12/10/08, German Geek wrote: Anybody agree or am i alone in this universe? Of course you are alone. As for the existence and history of the Universe, the Earth, you, or God -- it's all a matter of perception; and what you believe to be true; and on what the foundations you

Re: [PHP] A MySQL Question

On Tue, Dec 9, 2008 at 10:49 PM, Yeti <[EMAIL PROTECTED]> wrote: > As a matter of fact, in space you can't even scream. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > I don't know if there is a "better" or "best" solution to this,

Re: [PHP] A MySQL Question

As a matter of fact, in space you can't even scream. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] A MySQL Question

German Geek wrote: > On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > >> Robert Cummings wrote: >>> On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: >>> Ashley Sheridan wrote: > On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote: > >>

Re: [PHP] A MySQL Question

On Mon, 2008-12-08 at 23:50 -0800, Yeti wrote: > define('HUMAN_STUPIDITY', true); > function bigbang() { > while (HUMAN_STUPIDITY || !isset($debate_is_over)) { } > return true; > } > if (!isset($universe)) bigbang(); > ?> > > Who says the big bang is past? I can't hear it. Cheers, R

Re: [PHP] A MySQL Question

Who says the big bang is past? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] A MySQL Question

On Tue, 2008-12-09 at 17:40 +1300, German Geek wrote: > On Tue, Dec 9, 2008 at 3:51 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > > > German Geek wrote: > > > On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten <[EMAIL PROTECTED] > > > > wrote: > > > > > > Robert Cummings

Re: [PHP] A MySQL Question

On Tue, Dec 9, 2008 at 3:51 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > German Geek wrote: > > On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten <[EMAIL PROTECTED] > > > wrote: > > > > Robert Cummings wrote: > > > On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wr

Re: [PHP] A MySQL Question

Micah Gersten wrote: Robert Cummings wrote: On Mon, 2008-12-08 at 19:46 -0600, Micah Gersten wrote: Robert Cummings wrote: On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: Ashley Sheridan wrote: On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote

Re: [PHP] A MySQL Question

German Geek wrote: > On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten <[EMAIL PROTECTED] > > wrote: > > Robert Cummings wrote: > > On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: > > > >> Ashley Sheridan wrote: > >> > >>> On Mon, 2008-12-08 at

Re: [PHP] A MySQL Question

Robert Cummings wrote: > On Mon, 2008-12-08 at 19:46 -0600, Micah Gersten wrote: > >> Robert Cummings wrote: >> >>> On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: >>> >>> Ashley Sheridan wrote: > On Mon, 2008-12-08 at 23:23 +, [EMAIL P

Re: [PHP] A MySQL Question

On Mon, 2008-12-08 at 19:46 -0600, Micah Gersten wrote: > Robert Cummings wrote: > > On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: > > > >> Ashley Sheridan wrote: > >> > >>> On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote: > >>> > Presumable, the EXISTS sub-

Re: [PHP] A MySQL Question

On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > Robert Cummings wrote: > > On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: > > > >> Ashley Sheridan wrote: > >> > >>> On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote: > >>> > Presumable, the EXISTS s

Re: [PHP] A MySQL Question

Robert Cummings wrote: > On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: > >> Ashley Sheridan wrote: >> >>> On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote: >>> Presumable, the EXISTS sub-query can be optimized sometimes to just stop processing the sub-q

Re: [PHP] A MySQL Question

On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: > Ashley Sheridan wrote: > > On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote: > >> Presumable, the EXISTS sub-query can be optimized sometimes to just stop > >> processing the sub-query and kick things back out to the outer query.

Re: [PHP] A MySQL Question

Ashley Sheridan wrote: On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote: Presumable, the EXISTS sub-query can be optimized sometimes to just stop processing the sub-query and kick things back out to the outer query. IN has to process them all and find them all. Don't forget the

Re: [PHP] A MySQL Question

On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote: > Presumable, the EXISTS sub-query can be optimized sometimes to just stop > processing the sub-query and kick things back out to the outer query. > > > > IN has to process them all and find them all. > > > Don't forget the special

Re: [PHP] A MySQL Question

Presumable, the EXISTS sub-query can be optimized sometimes to just stop processing the sub-query and kick things back out to the outer query. IN has to process them all and find them all. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] A MySQL Question

On Mon, 2008-12-08 at 10:19 -0500, Andrew Ballard wrote: > On Sun, Dec 7, 2008 at 12:38 PM, Robert Cummings <[EMAIL PROTECTED]> wrote: > > On Sun, 2008-12-07 at 11:01 -0500, Eric Butera wrote: > >> Sounds like someone thinks they're pretty clever. I'll never > >> understand why interviewers want t

Re: [PHP] A MySQL Question

On Sun, Dec 7, 2008 at 12:38 PM, Robert Cummings <[EMAIL PROTECTED]> wrote: > On Sun, 2008-12-07 at 11:01 -0500, Eric Butera wrote: >> Sounds like someone thinks they're pretty clever. I'll never >> understand why interviewers want to ask really odd edge case questions >> instead of ones that real

Re: [PHP] A MySQL Question

On Mon, Dec 8, 2008 at 7:06 PM, Chris <[EMAIL PROTECTED]> wrote: > > Right >> >> So, how are these different: >> >> SELECT * FROM t1 WHERE id EXISTS (SELECT id FROM t2) >> > > If there are *any* results for the subselect, the exists returns true. > > It's the equivalent of: > > select * from

Re: [PHP] A MySQL Question

Right So, how are these different: SELECT * FROM t1 WHERE id EXISTS (SELECT id FROM t2) If there are *any* results for the subselect, the exists returns true. It's the equivalent of: select * from t1 where id is true; ie select * from t1; If there are no results for the subselect, t

Re: [PHP] A MySQL Question

On Mon, Dec 8, 2008 at 5:50 PM, Chris <[EMAIL PROTECTED]> wrote: > > Sorry, I couldnt find EXIST there, only EXISTS. >> >> >>If you're going to be that pedantic, "exist" isn't in mysqldump >>either :P >> >> I know it's pedantic, but unfortunately computers are strictly pedantic >>

Re: [PHP] A MySQL Question

Sorry, I couldnt find EXIST there, only EXISTS. If you're going to be that pedantic, "exist" isn't in mysqldump either :P I know it's pedantic, but unfortunately computers are strictly pedantic and I wasn't sure why you said "if exists" can be used in lots of places other th

Re: [PHP] A MySQL Question

On Mon, Dec 8, 2008 at 5:06 PM, Chris <[EMAIL PROTECTED]> wrote: > German Geek wrote: > >> >> >> On Mon, Dec 8, 2008 at 3:24 PM, Chris <[EMAIL PROTECTED] > [EMAIL PROTECTED]>> wrote: >> >> >> And 'exists' is not for mysqldump. >> >> >>DROP TABLE IF EXISTS `mytable`; >> >> >>"

Re: [PHP] A MySQL Question

German Geek wrote: On Mon, Dec 8, 2008 at 3:24 PM, Chris <[EMAIL PROTECTED] > wrote: And 'exists' is not for mysqldump. DROP TABLE IF EXISTS `mytable`; "if exists" can be used in lots of places other than "drop table", like triggers,

Re: [PHP] A MySQL Question

On Mon, Dec 8, 2008 at 3:24 PM, Chris <[EMAIL PROTECTED]> wrote: > > And 'exists' is not for mysqldump. >> >> >> DROP TABLE IF EXISTS `mytable`; >> > > "if exists" can be used in lots of places other than "drop table", like > triggers, functions and i'm sure other things. > > I said, I've see

Re: [PHP] A MySQL Question

And 'exists' is not for mysqldump. DROP TABLE IF EXISTS `mytable`; "if exists" can be used in lots of places other than "drop table", like triggers, functions and i'm sure other things. I said, I've seen EXIST in a result of a mysqldump before, which is not wrong is it? Unless I'm ha

Re: [PHP] A MySQL Question

On Mon, Dec 8, 2008 at 2:59 PM, Chris <[EMAIL PROTECTED]> wrote: > German Geek wrote: > >> EXIST? Yeah I certainly have seen it before in the result of a mysqldump, >> but from the top of my head, I probably wouldn't have known in exactly >> what >> context it is used. I've used MySQL for 5 years

Re: [PHP] A MySQL Question

German Geek wrote: EXIST? Yeah I certainly have seen it before in the result of a mysqldump, but from the top of my head, I probably wouldn't have known in exactly what context it is used. I've used MySQL for 5 years now and i think if you ask such a question, you don't know what you should be a

Re: [PHP] A MySQL Question

On Mon, 2008-12-08 at 12:33 +1300, German Geek wrote: > EXIST? Yeah I certainly have seen it before in the result of a mysqldump, > but from the top of my head, I probably wouldn't have known in exactly what > context it is used. I've used MySQL for 5 years now and i think if you ask > such a ques

Re: [PHP] A MySQL Question

EXIST? Yeah I certainly have seen it before in the result of a mysqldump, but from the top of my head, I probably wouldn't have known in exactly what context it is used. I've used MySQL for 5 years now and i think if you ask such a question, you don't know what you should be asking because the con

Re: [PHP] A MySQL Question

tedd wrote: Hi gang: I just interviewed for a job teaching at the local college (imagine me taking minds of mush and molding them to the world according to tedd -- frightening huh?) In any event, the interviewer asked me how long I've been using MySQL and I replied several years. After whic

Re: [PHP] A MySQL Question

Kevin Waterson wrote: Only a barbarian would call it "Sequel" or anything other than My S. Q. L "MY ESS KEW ELL" I have never heard that product "SQL Server" referred to as anything other than seequel server. Guess that proves your point :) Stephen -- PHP General Mailing List (http://w

Re: [PHP] A MySQL Question

This one time, at band camp, tedd <[EMAIL PROTECTED]> wrote: > In any event, the interviewer asked me how long I've been using MySQL > and I replied several years. After which she asked a single question, > which was "What does EXIST mean?" I only ever use it in rollbacks to check if a table ex

Re: [PHP] A MySQL Question

On Sun, 2008-12-07 at 12:38 -0500, Robert Cummings wrote: > On Sun, 2008-12-07 at 11:01 -0500, Eric Butera wrote: > > Sounds like someone thinks they're pretty clever. I'll never > > understand why interviewers want to ask really odd edge case questions > > instead of ones that really show practic

Re: [PHP] A MySQL Question

On Sun, 2008-12-07 at 10:03 -0500, tedd wrote: > Hi gang: > > I just interviewed for a job teaching at the local college (imagine > me taking minds of mush and molding them to the world according to > tedd -- frightening huh?) > > In any event, the interviewer asked me how long I've been using

Re: [PHP] A MySQL Question

On Sun, Dec 07, 2008 at 10:03:26AM -0500, tedd wrote: > Hi gang: > > I just interviewed for a job teaching at the local college (imagine me > taking minds of mush and molding them to the world according to tedd > -- frightening huh?) > > In any event, the interviewer asked me how long I've been usi

Re: [PHP] A MySQL Question

On Sun, 2008-12-07 at 11:01 -0500, Eric Butera wrote: > Sounds like someone thinks they're pretty clever. I'll never > understand why interviewers want to ask really odd edge case questions > instead of ones that really show practical knowledge. I know that I > don't know the syntax to everything

Re: [PHP] A MySQL Question

On Sun, 2008-12-07 at 10:03 -0500, tedd wrote: > Hi gang: > > I just interviewed for a job teaching at the local college (imagine > me taking minds of mush and molding them to the world according to > tedd -- frightening huh?) > > In any event, the interviewer asked me how long I've been using

Re: [PHP] A MySQL Question

On Sun, Dec 7, 2008 at 10:03 AM, tedd <[EMAIL PROTECTED]> wrote: > Hi gang: > > I just interviewed for a job teaching at the local college (imagine me > taking minds of mush and molding them to the world according to tedd -- > frightening huh?) > > In any event, the interviewer asked me how long I'

Re: [PHP] A MySQL Question

> To: PHP General Mailing List Date: Sun, 7 Dec 2008 10:03:26 -0500 Subject: [PHP] A MySQL Question > Hi gang: > > I just interviewed for a job teaching at the local college (imagine > me taking minds of mush and molding them to the world according to > tedd -- frightening huh

[PHP] A MySQL Question

Hi gang: I just interviewed for a job teaching at the local college (imagine me taking minds of mush and molding them to the world according to tedd -- frightening huh?) In any event, the interviewer asked me how long I've been using MySQL and I replied several years. After which she asked a

RE: [PHP] A MySQL question

mysql has no rowid. -Original Message- From: zavaboy [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2003 2:13 PM To: [EMAIL PROTECTED] Subject: [PHP] A MySQL question Ok, I want to delete only 1 row off of a database table... Example: I have a table with columns "user" and &qu

Re: [PHP] A MySQL question

Ok, I added a primary key. I figured it out and I have it working... Thanks! "Chris Shiflett" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > --- zavaboy <[EMAIL PROTECTED]> wrote: > > Lets say the table contains the following rows (user | item): > > 582-668243 | Toothbrush > > 582-6

Re: [PHP] A MySQL question

zavaboy <[EMAIL PROTECTED]> wrote: > Ok, I want to delete only 1 row off of a database table... > Example: > I have a table with columns "user" and "item"... > Lets say the table contains the following rows (user | item): > 582-668243 | Toothbrush > 582-668243 | Toothbrush Note the 'LIMIT' part in

Re: [PHP] A MySQL question

--- zavaboy <[EMAIL PROTECTED]> wrote: > Lets say the table contains the following rows (user | item): > 582-668243 | Toothbrush > 582-668243 | Toothbrush > 582-668243 | Toothbrush ... > Anyway, how can I remove only 1 Toothbrush from user 582-668243? With the information you provided, you can't.

[PHP] A MySQL question

Ok, I want to delete only 1 row off of a database table... Example: I have a table with columns "user" and "item"... Lets say the table contains the following rows (user | item): 582-668243 | Toothbrush 582-668243 | Toothbrush 582-668243 | Toothbrush 582-668243 | Trash can 582-668243 | Trash can 58