Hi.
Is there anyway to get a mysql server to tell me
a) What user I am connected as?
b) What host I am connected from (i.e., localhost vs. fqdn)?
c) What database I am using?
The reason for the question is that I want to print diagnostics in scripts
that don't contain connection information (it
EID 1 [none]
Preview ALL [none] [none] [none] [none] 150 [none]
(blank cells indicated by [none])
- BLH
>On 25 Jan 2001 15:15:35 -0500, Brian Hughes wrote:
> > Hi. Thanks, I like that syntax, I didn't know I could put STRAIGHT_JOIN
> > there after the SELECT.
> >
>
Thanks, but not really. I wish to get all the cases, even when there is no
Blurb in Preview. Your query only grabs cases where the Blurb in Preview
is missing by adding WHERE Preview.CASEID IS NULL. - Brian
- BLH
At 01:00 PM 1/25/2001 -0600, you wrote:
>Does this help?
>
>SELECT
>A
, Parties
>LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID
>WHERE CaseID.DocketNumber = ArgumentCalendar.Docket
>AND Parties.CASEID = CaseID.CASEID
>AND '20010125' <= ArgumentCalendar.Date
>
>On 25 Jan 2001 13:17:14 -0500, Brian Hughes wrote:
>
> &
perfect sense in separate tables with a person-key linking rows in these
tables to rows in the person table in a one-to-one relationship.
This assumes these 248 piece of data have some logical internal structure
that would group them into sets that could describe some entity.
My 2 cents.
- Bria
Hi. I have a query which works and is quick, but it misses a couple of
records.
SELECT ArgumentCalendar.Docket
, ArgumentCalendar.Date
, CaseID.CASEID
, CONCAT(Party1, ' v. ', Party2) AS name
, Preview.Blurb
FROM ArgumentCalendar
, CaseID
, Parties
, Preview
WHERE CaseID.DocketNumber = Argument
