problem in create table
Posted: Mon May 09, 2005 2:39 am
hi there....
see the above coad ...
what i want to do is : just to create a table where on evey insertion or updation it just maintain its current date and time? my question is that on whic version of mysql above query will work and my 2nd question is : is above code corrent and will it work?
Regards...
Code: Select all
CREATE TABLE t
(
ts1 TIMESTAMP NULL DEFAULT NULL,
ts2 TIMESTAMP NULL DEFAULT 0,
ts3 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
);what i want to do is : just to create a table where on evey insertion or updation it just maintain its current date and time? my question is that on whic version of mysql above query will work and my 2nd question is : is above code corrent and will it work?
Regards...