[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