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 examples
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
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 slave I
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 this
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
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 engine
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 General