in 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,
> It
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 doesn't seem to like the MAX(user