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" <euki@xxxxx> wrote in message news:20040716222541.99262.qmail@xxxxxxxxxxxxxxx > In article <20040716213419.55492.qmail@xxxxxxxxxxxx>, 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
