Thanks, But is there a way to do this without additional table in which to store the names of created temporary tables ?
Thanks, Rosen "Tim Van Wassenhove" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > In article <[EMAIL PROTECTED]>, Rosen wrote: > > 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 ? > > SELECT COUNT(*) AS count FROM temporary_table WHERE name='TMP21567'; > > Probably you'll want to make the name the primary key or at least > unique. This way you save yourself from adding duplicate entries with > the same name. > > -- > Tim Van Wassenhove <http://home.mysth.be/~timvw> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php