[thelist] mysql: datestamp compatibility pre version 4.1
Alex Beston
alex at deltatraffic.co.uk
Sat Feb 5 16:07:41 CST 2005
hi all
I have some creates from a mysql database that looks like it was version
after 4.1
Im running version Ver 11.18 Distrib 3.23.58; (ignore the ver 11.18 - i
think the manual[1] means the distrib part)
the manual [1] talks about:
CREATE TABLE t (ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP);
which is version 4.1.
and the line I have that i need to convert to 3.23 is:
`mem_timeout` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
where a sample data is :
2004-10-28 04:29:17
im fairly sure that this line isnt working because i have an older
version mysql.
how can I convert the syntax?
thanks,
Alex
[1]http://dev.mysql.com/doc/mysql/en/timestamp-4-1.html
--
Alex Beston
Business Director
deltaTraffic
Tel: 01273 691234
Room 32, Level 6,
New England House,
Brighton, England
www.deltatraffic.co.uk
--
More information about the thelist
mailing list