At 09:48 AM 1999-10-07 +0800, you wrote:
>
>Hi!
>
>How did you define the TIMESTAMP column? To get this to work with
>Access one must define is without a length modifier !
>
>For example:
>
>CREATE TABLE foo (a int not null primary key, b timestamp);
>
>The following will not work:
>
>CREATE TABLE foo (a int not null primary key, b timestamp(8));
>
>Regards,
>Monty
I have define the timestamp field without the length modifier
but a mysqldump test show that it is automatically create timestamp(14)
modifier. Below is a simple tables I create for testing. I don't define the
length modifer for timestamp field
during mysql database creation.
# MySQL dump 6.0
#
# Host: localhost Database: barry1
#--------------------------------------------------------
# Server version 3.22.26a
#
# Table structure for table 'telephone'
#
CREATE TABLE telephone (
name char(10) DEFAULT '' NOT NULL,
telephone char(10),
changedate timestamp(14),
PRIMARY KEY (name)
);
#
# Dumping data for table 'telephone'
#
INSERT INTO telephone VALUES ('barry','3456-5678',19991007144852);
INSERT INTO telephone VALUES ('gary','1234-1234',19991007144852);
INSERT INTO telephone VALUES ('may','2323-2323',19991007144852);
INSERT INTO telephone VALUES ('wong','2222-2222',19991007144852);
INSERT INTO telephone VALUES ('yan','1111-1111',19991007144852);
MS Access 97 still unable to update/delete record. In fact,
I have done numerous tests and I found that I can't do
update/delete when there is a column with the column type such as DATETIME,
DATE & TIMESTAMP. :-<
rgds
Barry
