Replication question to MySQL list

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: SET

MySQL Replication question

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_LOG_BIN =

datetime column altered to not null

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

RE: datetime column altered to not null

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 the colum

Distributed Query

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