is it possible to insert many rows into a heap table? I'm not sure how from the documentation. If not, are there other kinds of temporary tables that can be used?
I need to enter 100 rows into a table and then select them with order by. do I need to create a table, select the records I want, insert them with (INSERT INTO) to the temp table and then select with ORDER BY? I'm pretty sure there is a simpler way. P.S. the records I need to enter the tem table are from a script so I can't do it all at once in the DB, I have to create a temp table. thanks berber --------------------------------------------------------------------- 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
