Re: [PHP-DB] Temporary table name

2004-07-16 Thread Rosen
Thanks, I'll try it. "John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Rosen wrote: > > > No, I don't use it only in range of one script - it must be as "normal" > > table - several scripts to work with this table and after the last script > > finish - it delete the ta

Re: [PHP-DB] Temporary table name

2004-07-16 Thread John W. Holmes
Rosen wrote: No, I don't use it only in range of one script - it must be as "normal" table - several scripts to work with this table and after the last script finish - it delete the table. This may take a time about 20-30 minutes ( until user enter data ) Okay. Use uniqid() to create a string for t

Re: [PHP-DB] Temporary table name

2004-07-16 Thread Rosen
No, I don't use it only in range of one script - it must be as "normal" table - several scripts to work with this table and after the last script finish - it delete the table. This may take a time about 20-30 minutes ( until user enter data ) "John W. Holmes" <[EMAIL PROTECTED]> wrote in message n

Re: [PHP-DB] Temporary table name

2004-07-16 Thread John W. Holmes
Rosen wrote: Yes, I'm creating temporary table to store temporary data and after thath I delete this temporary table. What is the longest table name (in chars) fo MySQL table name ? How long does it exist for? If it's only used during the life of the script, then use TEMPORARY when you create it a

Re: [PHP-DB] Temporary table name

2004-07-16 Thread Rosen
Yes, I'm creating temporary table to store temporary data and after thath I delete this temporary table. What is the longest table name (in chars) fo MySQL table name ? Thanks in advance Rosen "John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Rosen wrote: > > I need t

Re: [PHP-DB] Temporary table name

2004-07-16 Thread John W. Holmes
Rosen wrote: I need to create temporary table in mysql. And I generate random name - i.e. "TMP21567". How can I check is this name already exist in database ? If you're creating a true temporary table, then you don't need to worry about the name being unique. CREATE TEMPORARY TABLE tmp21567 ... E

[PHP-DB] Temporary table name

2004-07-16 Thread Rosen
Hi, I need to create temporary table in mysql. And I generate random name - i.e. "TMP21567". How can I check is this name already exist in database ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php