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 Bur
9 because 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/
:o)
Jamie.
- 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
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: "
times (this is where 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
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
6ben
a default 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.
t me trying to make things too efficient...
jamie.
- 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
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
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.
y is great for my search engine because it ranks the results 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 M
11 matches
Mail list logo
