469 228 2183
>
>
> -Original Message-
> From: Michael Stassen [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 14, 2005 8:28 AM
> To: [EMAIL PROTECTED]
> Cc: Gleb Paharenko; mysql@lists.mysql.com
> Subject: Re: Auto loading a table
>
>
> [EMAIL P
respectful 4 days.
Thanks
Donny Lairson
President
29 GunMuse Lane
P.O. box 166
Lakewood NM 88254
http://www.gunmuse.com
469 228 2183
-Original Message-
From: sol beach [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 13, 2005 3:11 PM
To: [EMAIL PROTECTED]
Subject: Re: Auto loading a table
With
:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 8:28 AM
To: [EMAIL PROTECTED]
Cc: Gleb Paharenko; mysql@lists.mysql.com
Subject: Re: Auto loading a table
[EMAIL PROTECTED] wrote:
> [Donny Lairson] Quick bump I never got an answer
>
> I have a table fsearch_temp I use it as a memory
[EMAIL PROTECTED] wrote:
> [Donny Lairson] Quick bump I never got an answer
>
> I have a table fsearch_temp I use it as a memory table to keep things
> light and fast but after a restart I want to repopulate some data
> automatically. So I thought I just said load from TEST2 which would by a
> m
Hello.
>) ENGINE = MEMORY LOAD FROM TEST2 DEFAULT CHARSET = utf8 AUTO_INCREMENT =0
You should use select statement, not LOAD. For example:
CREATE TABLE . SELECT * FROM TEST2;
And table options like DEFAULT CHARSET you should put before select statement.
See:
http://dev.mysql.com/
[Donny Lairson] Quick bump I never got an answer
I have a table fsearch_temp I use it as a memory table to keep things
light and fast but after a restart I want to repopulate some data
automatically. So I thought I just said load from TEST2 which would by a
myisam table containing the hardba
I have a table fsearch_temp I
use it as a memory table to keep things light and fast but after a restart I
want to repopulate some data automatically. So I thought I just said load
from TEST2 which would by a myisam table containing the hardbackup I need.
But obviously not the right way of
