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
