t;
> Christian
>
> -Original Message-
> From: Rhino [mailto:[EMAIL PROTECTED]
> Sent: Saturday, 15 January 2005 12:56 AM
> To: Christian Biggins; mysql@lists.mysql.com
> Subject: Re: Selecting a random record from more than 1 table
>
>
> - Original Message -
- Original Message -
From: "Christian Biggins" <[EMAIL PROTECTED]>
To:
Sent: Friday, January 14, 2005 12:07 AM
Subject: Selecting a random record from more than 1 table
> Hi Guys
>
> I am trying to display 1 random record taken from 2 tables.
>
> I have
Hi Guys
I am trying to display 1 random record taken from 2 tables.
I have tried the following;
SELECT table1.record1, table1.record2, table2.record1 FROM table1, table2
ORDER BY RAND() Limit 1
With no luck... So now I am trying to use CREATE VIEW but also with no
luck... Can anybody help out?
15:15
> To: [EMAIL PROTECTED]
> Subject: FW: Selecting a random record
>
>
> Any idea why I get this error when I try to create this table
> on a clean
> 3.23.30 install on a BSDI box.
> This was the output from a mysqldump from version 2.22.32 on a working
> datab
Any idea why I get this error when I try to create this table on a clean
3.23.30 install on a BSDI box.
This was the output from a mysqldump from version 2.22.32 on a working
database. It will not allow me to recreate my database on the new version.
mysql> CREATE TABLE pp_additional_features (
To simplify
SELECT Field1, Field2, Field3 ORDER BY Rand() LIMIT 1;
At 10:01 AM 1/15/2001 -0700, Alan Halls wrote:
> On the site Adoption.com we have been using a mysql database to
> set up
>families who want to adopt. We have since redesigned our site and the old
>code is not working fo
On the site Adoption.com we have been using a mysql database to set up
families who want to adopt. We have since redesigned our site and the old
code is not working for us. I am trying to design a section of code in ASP
to connect to the database and return a random record. Here is what I
