I have seen this on 3.23.x and 4.0.x mysql, too. DROP TABLE temp_tablename; works OK. Any further discussion should go to mysql list. Good luck, Doug On Fri, 18 Apr 2003 09:53:03 +0200, Merlin wrote: >Hi there, > >somehow the syntax explained on mysql to drop a tmp table is wrong. The db >returns wrong statement. > >Has anybody the same problems?? > >Thanx Merlin > >http://www.mysql.com/doc/en/DROP_TABLE.html >6.5.6 DROP TABLE Syntax > >DROP [TEMPORARY] TABLE [IF EXISTS] tbl_name [, tbl_name,...] [RESTRICT | >CASCADE] > > >------------------------------- >Worldwide Travel Community >http://www.globosapiens.net > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php