3 21:36
To: Dathan Vance Pattishall; [EMAIL PROTECTED]
Subject: RE: Hmm looks like this query works
I think your query will just return the first 10 values in the table sorted
in random order due to how MySQL handles queries that use ORDER BY and
LIMIT:
[from mysql documentation]
If you use LI
Try this instead...
SELECT val_column, 0.1+RAND() as rand_col from TABLE ORDER BY rand_col limit
10;
Cheers,
A
-Original Message-
From: Eric Wagner [mailto:[EMAIL PROTECTED]
Sent: Tuesday 10 June 2003 21:36
To: Dathan Vance Pattishall; [EMAIL PROTECTED]
Subject: RE: Hmm looks like
I think your query will just return the first 10 values in the table sorted in random
order due to how MySQL handles queries that use ORDER BY and LIMIT:
[from mysql documentation]
If you use LIMIT # with ORDER BY, MySQL will end the sorting as soon as it has found
the first # lines instead of s
hieve the same result with 1 row.
-->-Original Message-
-->From: Becoming Digital [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, June 10, 2003 11:33 AM
-->To: [EMAIL PROTECTED]
-->Subject: Re: Hmm looks like this query works
-->
-->What's your end goal, and for what
What's your end goal, and for what do you need/desire a "weighted random?" Your
objective will determine if this is actually of use or if it simply appears to
be.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Dathan Vance Pattishall" <[EMAIL PROTECTE
I missed the original question but here is my two cents.
The solution has to do with how you define "... used as a online database". Steve
Rapaport is correct if you want to create a database accessable via a browser, but
if you just want a database available on the net all you need (on the se
By the way you're using the terms, I would guess you're hoping
to make a new database, and place it "on the web".
In that case, Mysql is probably at too low a level of
detail for your needs. To solve your problem you
would need to learn:
HTML
CGI
middleware (ASP, PHP, etc)
MySQL
SQL
database
* Harry Rorarius
> I thought Mysql was a server that could be used as a online database?
Yes, it is...
> If it is, is there some material I have not read that tells me how to do
> this?
Probably :o)
> I understood most of the information I read about Mysql. I was under the
> understanding sql
Harry,
It is you need to make a WEB front end to access it
-Original Message-
From: Harry Rorarius [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 10:49 AM
To: Mysql list
Subject: hmm
ok
I thought Mysql was a server that could be used as a online database?
If it is, is ther
On Thursday 28 March 2002 9:48 am, Harry Rorarius wrote:
> I thought Mysql was a server that could be used as a online database?
Yes
> If it is, is there some material I have not read that tells me how to do
> this?
What are you trying to do? You have not been at all clear in y
10 matches
Mail list logo
