Re: MySQL v3.23.52-MAX on Win32

2002-11-24 Thread Pae Choi
Thanks. That explains it. Pae > The first column of type timestamp will always be initialized with the > current timestamp. See the fourth and fifth paragraphs of the following > link. > > http://www.mysql.com/doc/en/DATETIME.html > > > Isn't it suppose to be 'NULL'? Thanks > > -- > Linux: Beca

Re: MySQL v3.23.52-MAX on Win32

2002-11-24 Thread Chase Urich
The first column of type timestamp will always be initialized with the current timestamp. See the fourth and fifth paragraphs of the following link. http://www.mysql.com/doc/en/DATETIME.html > Isn't it suppose to be 'NULL'? Thanks -- Linux: Because rebooting is for adding hardware. Fingerprint

MySQL v3.23.52-MAX on Win32

2002-11-24 Thread Pae Choi
I have created a test table for different data types as follows: CREATE TABLE AllDataTypes ( id INTEGER, col_bit BIT, col_boolean BOOL, col_tinyint TINYINT, col_smallint SMALLINT, col_int INT, col_integer INTEGER, col_bigint BIGINT, col_float FLOAT, col_double DOUBLE, col_char