Hi folks,
I hope that dumb questions are allowed in here ...
I have two MySQL tables and I would like to delete records from one
based on associated values in another. For example, using the example
tables below, how would I delete all the records in the TIDS table that
had an associative value
Hello all ... be gentle, I'm new at this:
I've got a simple case query. One works (the top one), but when I try
to add additional columns to the query it fails. I reckon it's a pretty
simple mistake I'm making, but I don't know what. Any help is
appreciated.
---
e-
> From: Jon Wagoner [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 24, 2003 4:34 PM
> To: Richard Forgo; MySQL Mailing List
> Subject: RE: case expression
>
> Put the other fields after the CASE statement:
>
> SELECT
> CASE
> WHEN CHARACTER_LENGT
1 PM
> To: Richard Forgo; MySQL Mailing List
> Subject: RE: case expression
>
> Consider the CASE statement to be a function, that can only return
values.
> Aliases would go outside the CASE STATEMENT, as follows:
>
> SELECT
> CASE
> WHEN CHARACTER_LENGTH(system)
Did Big Larry go open source? This is news to me. If you have more
details, please provide the list a link to share that info.
Rik Forgo
JIST3
Army Test & Training Investment Conference (ATTIC)
Diverse Technologies Corp.
(c) 410.852.7420
(h) 410.859.8474
-Original Message-
From: MadProf
I'll try not to extend this thread any more than it needs (it's gone
pretty far now). If you want to view the list via Usenet newsgroup,
just do it. It's been available on my service provider for several
months at mailing.database.mysql. If you prefer via email, fine.
Rik Forgo
JIST3
Army Test
I'm trying to find some documentation on creating intersecting entities
in MySQL, but haven't been able to track any info down on the MySQL site
or on the web. At least we called them intersecting entities while I
was in Oracle training (which was some time ago). I think I remember
how to set the
JIST3
Army Test, Training and Technology Integration Office (T3I)
Diverse Technologies Corp.
(c) 443.463.8571
(h) 410.859.8474
> -Original Message-
> From: John Ragan [mailto:jragan@;arkansas.net]
> Sent: Wednesday, November 06, 2002 6:55 PM
> To: [EMAIL PROTECTED]; Richard Forgo
&g
Corp.
(c) 443.463.8571
(h) 410.859.8474
> -Original Message-
> From: John Ragan [mailto:jragan@;arkansas.net]
> Sent: Thursday, November 07, 2002 10:16 AM
> To: [EMAIL PROTECTED]; Richard Forgo
> Subject: RE: Newbie: Intersecting entities
>
>
> aha! sure. you w
