Hi. On Thu, Dec 13, 2001 at 03:50:01PM +0200, [EMAIL PROTECTED] wrote: > > is it possible to insert many rows into a heap table?
Yes. By the way, why didn't you simply try out yourself? > I'm not sure how from the documentation. The same way as with other table types. > If not, are there other kinds of temporary tables that can be used? "temporary tables" are a special table property, which several table types can have (ISAM, MyISAM, HEAP). HEAP tables reside purely in memory (as long as the server runs or they are explicitly deleted), whereas TEMPORARY table are only "visible" for the current connection and will be dropped automatically when the connection is closed. http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/H/E/HEAP.html http://www.mysql.com/doc/T/e/Temporary_table_problems.html > 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. Sorry, I wasn't able to discern what you want to accomplish, so I cannot say if there is an easier way. Bye, Benjamin. > 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 [...] -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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
