Re: timestamp & not null

2006-04-10 Thread Martijn Tonies
> I need to create a "commands" table. A program will periodically check on this table whether > there's a pending command for it to execute or not. Whatever the reason, this program might read a command but not acknowledge it's > execution. > Other program will check out whether the command t

Re: timestamp & not null

2006-04-10 Thread [EMAIL PROTECTED]
10/04/2006 11:51 Para: <[EMAIL PROTECTED]>, Asunto: Re: timestamp & not null 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 nul

Re: timestamp & not null

2006-04-10 Thread Martijn Tonies
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 &quo

timestamp & not null

2006-04-10 Thread [EMAIL PROTECTED]
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"