> 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
> 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
What is it that you're trying to do?
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!