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
> 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_da
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