- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Thursday, December 30, 2004 9:03 AM
Subject: Need help with SELECT
> I am trying to think of SQL that will let me show a one to many
relationship
> as a single row in a result se
> There is one record in the Events table for each event that an organization
> is promoting. For each event, there could be 0 to 'n' files that give more
> information about the event, such as pictures, audio clips, or whatever. I
> want to display all the information about the event, including al
I am trying to think of SQL that will let me show a one to many relationship
as a single row in a result set. They say a picture is worth a thousand
words so let me draw that picture.
Event_IDEvent_Nameetc.
1 Concert
2 Art Exhibit
3 Spelling Bee
[P
At 4:20 -0500 7/7/03, Anthony Scism wrote:
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time | time | YES | | NULL |
|
| object | varchar(40) | YES | | NULL
Scism さんは書きました:
> Thank you very much, I should have thought of that.
>
> -Original Message-
> From: Nils Valentin [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 07, 2003 4:34 AM
> To: Anthony Scism; [EMAIL PROTECTED]
> Subject: Re: need help with select stat
Hi Antony,
Eventually "key" is a reserved word ?? ;-)
nice one !!
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 7日 月曜日 18:20、Anthony Scism さんは書きました:
> I am relatively new at this, but is there any way to perform the
>
> following:
> | obs_date | date | YES | | NULL
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time | time | YES | | NULL |
|
| object | varchar(40) | YES | | NULL |
|
| observing_site | varchar(40)
I'm no expert in this in fact I just recently started playing with
joins, but here's one that I actually used for a recent shopprt cart
piece. I appologise if it wraps but the output is long...content
conatins the basic content info but product contains the list of prices.
Yes I could have jus
Hi,
I have two tables:
mysql> describe eventlog;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-++
| id | int(10
You can join all three tables together
select d.members_id, m.name, old.name from data as d
left join members as m on m.members_id=d.members_id
left join oldmembers as old on old.members_id=d.members_id
If the members_id belongs to an old member, all fields from the member table
>Can't you just make a check before you make a call to the DB?
>if( member_id > 1000 )
> // old member query here
>else
> // new member query here
Now I did just that, but that means I have to open recordset 20 times a page
(for each record separately)...
I am a begginer, I don't kn
ED]
Amne: Re: Need help with SELECT 2 tables from choice of 3
>>Why no have 3 tables:
>>Members
>>Data
>>TheseMembersAreOld
>>Members and Data are as you have them defined. TheseMembersAreOld
>>contains only the Member_ID field.
>>You then make the Mem
>>Why no have 3 tables:
>>Members
>>Data
>>TheseMembersAreOld
>>Members and Data are as you have them defined. TheseMembersAreOld
>>contains only the Member_ID field.
>>You then make the Member_ID field primary key on TheseMembersAreOld and
>>Members. You can then perform a very fast joins.
>H
> OldMembers
> Memebers
> Data
Why no have 3 tables:
Members
Data
TheseMembersAreOld
Members and Data are as you have them defined. TheseMembersAreOld
contains only the Member_ID field.
You then make the Member_ID field primary key on TheseMembersAreOld and
Members. You can then perform a very
Hi there
I need help :-)) If anybody could be so kind and help me...
I have 3 tables:
OldMembers
Memebers
Data
In Data there is a field Member_ID. Now in this field all members bigger than
100.000 are old ones and must be taken from the OldMembers table (both tables
are not using same data so
On Thursday 30 August 2001 15:28, Andre Konopka wrote:
> Hi,
>
> I have, three tables (one,two, three) with the rows id/value. id is the
> key for all the tables.
>
>
> with
>
>
> select value from one where id=xx;
> select value from two where id=xx;
> select value from three where id=xx;
>
>
> I
Hi,
I have, three tables (one,two, three) with the rows id/value. id is the
key for all the tables.
with
select value from one where id=xx;
select value from two where id=xx;
select value from three where id=xx;
I can select all values from the tables with the id=xx.
How can I do this wit
Thanks Rolf
>From: "Rolf Hopkins" <[EMAIL PROTECTED]>
>To: "David Jacobowitz" <[EMAIL PROTECTED]>,
><[EMAIL PROTECTED]>
>Subject: Re: Need help with select statement.
>Date: Tue, 27 Feb 2001 09:21:57 +0800
>
>No it's not pos
No it's not possible but you can just read in all tables anyway and ignore
the columns you don't want.
- Original Message -
From: "David Jacobowitz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 7:33
Subject: Need help wit
Dear Sir,
I have looked in the manual but could not find any clue so I am seeking your
assistance. I have a table with 25 fields and I use most of these fields but
not all in different DBI scripts. Currently I use:
SELECT field_1, field_4, ...getting tired typing field names... FROM myTest;
I
20 matches
Mail list logo