On Wed, Jan 15, 2003 at 11:55:44PM +0000, [EMAIL PROTECTED] wrote:
>
> please look at page 194 of the reference manual...
>
> >(and if so how do you ask MySQL to create a temp table from the
> > results of aquery?)
>
> here's an example:
>
> mysql> create temporary table tmp (name varchar(20), owner varchar(20, species
>varchar(10));
>
> mysql> insert into tmp select name, owner, species from pet where species='Dog';
Or in 1 go:
create temporary table tmp select name, owner, species from pet where species='Dog';
Of it is small:
create temporary table tmp type=heap select name, owner, species from pet where
species='Dog';
for memory based one.
Harmen
(Sql, select, etc)
--
The Moon is Waxing Gibbous (95% of Full)
tty.nl - 2dehands.nl: 59340
---------------------------------------------------------------------
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
