From: Agrin, Nathan (Nathan.Agrinumassmed.edu)
Date: Wed Feb 18 2004 - 13:21:53 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Kind of what I was thinking of. How can I generate a unique identifier?

-Nate

-----Original Message-----
From: Keith C. Ivey [mailto:keithsmokefreedc.org]
Sent: Wednesday, February 18, 2004 2:18 PM
To: mysqllists.mysql.com
Subject: Re: Temporary table issues. Do I need persistent connections
with php?

Even with persistent connections, you can't use a temporary table on
a later HTTP connection (Web request), because you don't know that
your new HTTP connection will get the same MySQL connection that you
used before.

It should work to use a temporary table in a series of queries to get
data to display on a page in response to a single HTTP request, but
if you need to save data through a series of HTTP requests (a
session), you'll need normal tables. You can create a table using
some unique ID in the name and then drop it when you're finished with
it. It will exist temporarily, but it won't be a TEMPORARY table in
the MySQL sense.

--
Keith C. Ivey <keithsmokefreedc.org>
Tobacco Documents Online
http://tobaccodocuments.org

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=nathan.agrinumassmed.edu

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]