Try this: CREATE TEMPORARY TABLE TMP SELECT USER() AS UserId or CREATE TABLE TMP SELECT USER() AS UserId
and u get: ERROR 2013: Lost connection to MySQL server during query running MySQL 4.0.3-Beta-log on RH linux 7.2 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Alejandro D. Burne Sistemas AMR Asociación Médica de Rosario España 401 - Rosario (2000) Teléfono +54 (0341) 4252313 Int.145 Santa Fe - Argentina ICQ #4304494 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.386 / Virus Database: 218 - Release Date: 9/09/02 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php