n subsequent queries? If so when does this variable
expire? When you close the connection?
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 2:40 AM
To: David V. Edelstein
Subject: RE: Random Select Statement??
> Sorry Roger,
>
* David V. Edelstein
> I would like to create a mySQL query that will find the max
> user_id, use this value to calculate a random value of the
> user_id from [1 thru max], then return the entire row for
> that person(user_id) filled in with that persons(row) four
> entities, which I can use to po
* David V. Edelstein
> I'm trying to create a select statement that will go into a table find the
> number of rows in the table then select a single random row and
> return it. I
> am using Java/mySQL with the mm.mysql JDBC drivers. I've been
> playing around
> with the following statement but it