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]