List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 22 1999 11:23pm
Subject:Re: timestamp (before: auto_increment question)
View as plain text  
At 5:58 PM -0500 7/22/99, Denis Voitenko wrote:
>I think I am doing something wrong with timestamp. As far as I understand
>it, is should update automatically upon query execution. So, I created a
>table:
>
>create table chat (who varchar(8), said varchar(255), time timestamp);
>
>and insert values like this:
>
>insert into chat values("Denis","Hello, everyone!","");
>
>but when I do:
>
>select * from chat I get stuff like:
>
>+-------+-----------------+----------------+
>| who   | said            | time           |
>+-------+-----------------+----------------+
>| denis | hello, everyone | 00000000000000 |
>| denis | hello, everyone | 00000000000000 |
>| denis | bye             | 00000000000000 |
>+-------+-----------------+----------------+
>
>that is time column data does not change. How do I fix that?


Insert NULL, not an empty string.

--
Paul DuBois, paul@stripped
Thread
auto_increment questionDenis Voitenko22 Jul
  • Re: auto_increment questionNem W Schlecht22 Jul
    • Re: auto_increment questionDenis Voitenko23 Jul
      • Re: auto_increment questionThimble Smith23 Jul
    • Re: auto_increment questionDenis Voitenko23 Jul
      • Re: auto_increment questionThimble Smith23 Jul
      • Re: auto_increment questionBill Gerrard23 Jul
        • timestamp (before: auto_increment question)Denis Voitenko23 Jul
          • Re: timestamp (before: auto_increment question)Thimble Smith23 Jul
          • Re: timestamp (before: auto_increment question)Paul DuBois23 Jul
  • Re: auto_increment questionPaul DuBois22 Jul