they didnt
exist in the table.
Can anybody give me any clues how to achieve this?
Thanks,
Jamie Burns.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
i actually need the id's with no row returned as if they were there (but
with default values)... they do not need to be inserted into the table, just
returned as if they were in there.
j
- Original Message -
From: sherzodR [EMAIL PROTECTED]
To: Jamie Burns [EMAIL PROTECTED]
Cc: [EMAIL
Hello again :o)
This is surely an easy quick one but my brain wont work!
I have a table (ref, name, team, seminar_ref) like:
1billsupport100
2billsupport101
3billsupport102
4ben development 201
5ben development 103
6
your query
gets 9 from).
:o(
- Original Message -
From: Stefan Pinkert [EMAIL PROTECTED]
To: Jamie Burns [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, September 14, 2001 2:25 PM
Subject: Re: surely an easy quick one
select count(*) from table where team='support' group by team
this doesnt work as i need either :o(
it returns 3 rows, each with a count of 3 inside. i just want to get a
*single row* with the number 3 in it (for my example).
:o(
thanks for trying though...
- Original Message -
From: Lezz Giles [EMAIL PROTECTED]
To: Jamie Burns [EMAIL PROTECTED
.
- Original Message -
From: Lezz Giles [EMAIL PROTECTED]
To: Jamie Burns [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Friday, September 14, 2001 2:29 PM
Subject: Re: surely an easy quick one
I haven't tested this; I'm not an SQL guru. I just
like a challenge :-)
SELECT COUNT(*) FROM table WHERE
value to the 'rating' column if actual
row(s) do not exist in the ratings table? I dont really want to have to make
a dummy rating row just to trick it into working.
Am i making sense? I hope so ;o)
Jamie Burns.
-
Before posting
3, has an average rating of 2.5
and could i possibly return the 10 highest rows?
any help with this would be really appreciated...
jamie burns.
hi..
can someone tell me how i get the data from two tables, where table1 will have one
row, and table2 will have many rows?
eg:
table1:
idname
1barney
2fred
3wilma
table2:
idstudent_id subject
11
.
- Original Message -
From: Dennis Salguero [EMAIL PROTECTED]
To: Jamie Burns [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, August 05, 2001 10:32 PM
Subject: Re: quickie!
Are you looking for:
SELECT table1.name, table2.subject
FROM table1, table2
WHERE table1.id=table2
based
on how many keywords were found in each row (users love this).
i know have to think about making it portable (i found the if() statement
didnt work in PostgreSQL).
are there any portable equivilents to this MySQL specific query?
thanks for your thoughts,
jamie burns
11 matches
Mail list logo