> Replication with temporary table issue:
> HostA: MySQL 3.23.42-log
> HostB: MySQL 3.23.42
>
> Replication: HostA --to--> HostB
>
> Issue: After followed the MySQL Manual recommendation to: SET SQL_LOG_BIN
> = 0;
> to create, insert and drop a temporary table,
> example:
>SE
> Replication with temporary tables:
> HostA: MySQL 3.23.42-log
> HostB: MySQL 3.23.42
>
> Replication: HostA --to--> HostB
>
> Issue: After followed the MySQL Manual recommendation to: SET SQL_LOG_BIN
> = 0;
> to create, insert and drop a temporary table,
> example:
>SET SQL
Hi guys,
Could you please tell us if can I make a distributed query inside ob mysql>
Something like :
SELECT A.c1, b.c2 from serverA.TableA A, serverB.TableB B
Or if this functionality is schedule for a future (which) release.
Thank you much in advance.
Edgart
Hi,
We have a table (170K rows) and we altered the colum 'created_date' to not
null with default value to '1900-01-01 00:00:00' , after the alter column
statement is complited we select for the same column for nulls and I found
13K rows with null value
select * from table1 where creted_date is
Oops we are running mysql 3.23.42 on linux 7.1
-Original Message-
From: Edgart Gonzalez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 11:54 AM
To: '[EMAIL PROTECTED]'
Subject: datetime column altered to not null
Hi,
We have a table (170K rows) and we altered
