Re: timestamp (before: auto_increment question)

[Thimble Smith]

At 18:58, 19990722, Denis Voitenko wrote:
>create table chat (who varchar(8), said varchar(255), time timestamp);
>
>and insert values like this:
>
>insert into chat values("Denis","Hello, everyone!","");

Whoa!  "" is not the same as NULL!  Not even close to being anything
at all like NULL.  Do this instead:

    INSERT INTO chat (who, said)
    VALUES ("Denis", "Hello, everyone!");

Or, if you feel like you have to list all of the fields, do:

    INSERT INTO chat (who, said, time)
    VALUES ("Denis", "Hello, everyone!", NULL);

Tim