In MySQL is it possible to create a temporary table without having to specify all the properties? On SQL Server (at least via query analyzer) you can create temp tables fairly easily and the properties of each field are inherited from the regular table.
Doesn't look like thats the case with MySQL, but it doesn't hurt to ask first ;) chris --------------------------------------------------------------------- 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