Re: Can't create NOT NULL timestamp

[Jan Kowalski]

Hi,

Thank you for the response.
I've tried your idea, my result is different from yours though:
mysql> CREATE TABLE `test` (
`id` int(10) unsigned auto_increment,
`startTime` timestamp,
PRIMARY KEY (`id`) )
ENGINE=ndb;
mysql> show create table test \G
[...]
`startTime` timestamp NULL DEFAULT NULL,
[...]


Your version achieves not null, but with a default. I want to force inserts to provide a 'startTime' value.