On Wed, Jul 21, 2004 at 05:07:46PM +0200, Michael Kleiser wrote:
> create temporary table tmp_foo AS select * from foo;
Ah, that's a relief, thanks. Just what I need. Must have missed it in
the create table syntax.
> Geoff Richards schrieb:
> >Hi,
> >
> >I've got some code that currently uses M
create temporary table tmp_foo AS select * from foo;
Geoff Richards schrieb:
Hi,
I've got some code that currently uses MySQL, and it copies an existing
table into a temporary one like so:
create temporary table tmp_foo select * from foo;
That creates 'tmp_foo' with the same columns as 'foo', wh
Hi,
I've got some code that currently uses MySQL, and it copies an existing
table into a temporary one like so:
create temporary table tmp_foo select * from foo;
That creates 'tmp_foo' with the same columns as 'foo', which is
very convenient. I can't seem to find any reference to how to do
t
