Hi!

I created a table and, into it, a timestamp field:
... EXPIRES TIMESTAMP NOT NULL, ...

When I issue the command "describe" it shows the field "expires" allows nulls 
and defaults to CURRENT_TIMESTAMP. Also, each time I update 
a field other than "expires" in this table, "expires" gets updated to the 
current timestamp.

Does anybody know how can I make a timestamp field be "not null"?
Lots of thanks to you all.


Prueba el Nuevo Correo Terra; Seguro, RĂ¡pido, Fiable.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to