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 > > ++--

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

I believe I've seen EXIST used when creating backups of tables to test for the existence of a table and DROP it if it exists (if you select the option to add such code in phpMyAdmin). So that would have been my answer (give or take more specific wording for an interview). As for pronounciation

RE: [PHP] A MySQL question

You have made a mistake in your database design. Every table should have a primary key that allows you to uniquely identify any single row in the table. You do not have a primary key, hence when you want to delete a single row from a series of duplicates, you can't do it. Unlike oracle, mysql ha

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.