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" <holmes072000@xxxxxxxxxxx> wrote in message news:40F86E41.7030501@xxxxxxxxxxxxxx > 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 and you can use anything > for the name. You don't have to worry about it being unique. > > -- > ---John Holmes... > > Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ > > php|architect: The Magazine for PHP Professionals ? www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php