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.
If you want to store date/time values, do not use the TIMESTAMP datatype. What is it that you're trying to do? Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]