On 5/3/06, Barry <[EMAIL PROTECTED]> wrote:
Cummings, Shawn (GNAPs) schrieb:
>
> If I have 4 Fields (FIELD1, FIELD2, FIELD3 & FIELD4)
>
> I can do this easily;
>
> UPDATE TABLE_NAME SET FIELD4 = FIELD1;
>
> But -- how do I do it so that FIELD4 = FIELD1 & FIELD2 ??? I can't seem
> to find any
On 4/27/06, Brian J. Matt <[EMAIL PROTECTED]> wrote:
> As the items move new time stamped entries are added to the
> database. How would you query to find the current location of all
> the items currently in the system. As you might expect we don't want
> to replace the entry for an item when a l
On 4/12/06, Tim Lucia <[EMAIL PROTECTED]> wrote:
> Would you not lock tables on the slave? The idea of catching it up implies
> this is way it is done. Catching up means once replication can proceed once
> the tables are unlocked (on the slave).
>
> At least that is the way I read it...
On the s
On 4/11/06, Dana Diederich <[EMAIL PROTECTED]> wrote:
> We use a dedicated replicated instance for backups.
>
> Every night, we lock all of the tables, and dump all of them to
> compressed files, and unlock them afterwards. It takes a while to catch
> up, but that doesn't hurt anything.
I too use
On 3/28/06, Peter Brawley <[EMAIL PROTECTED]> wrote:
> >I require something along the lines of this:
>
> >CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE
>
> CREATE TABLE tblname ENGINE=archive SELECT * FROM request_log;
>
> PB
Excellent. Exactly what I need. Thanks :-)
--
MySQL Gene
On 3/28/06, Pure Web Solution <[EMAIL PROTECTED]> wrote:
> I dont think that it is possible to specify the engine when creating a table
> this way, you could however create the table using the:
>
> CREATE TABLE old AS SELECT * FROM request_log
>
> and then issue an alter table command setting the e
Hi,
I'm using MySQL 4.11. Is it possible to use the CREATE TABLE x AS
syntax alongside the ENGINE = x pragma, since this would make
archiving of tables very simple.
I require something along the lines of this:
CREATE TABLE old AS SELECT * FROM request_log ENGINE=ARCHIVE
If this cannot be done t
