On 08.02.2001 15:09:47 Christian Ribeaud wrote:
> would like that the table put automatically the today's date for every INPUT
as
> default value. What is wrong?
Uhm, why don't you use a timestamp column type then? Okay, it will also save
the time, but it's easy to extract only the date, if that's all your after.
With a timestamp, you could either not set any value when inserting or set it to
NULL which both would enter the current time (like in NOW()).
> Another question, 'showIt ENUM('TRUE') DEFAULT ERROR' did not work but 'showIt
Sure, because your ENUM did not contain the value 'ERROR' - it's just containing
'TRUE'.
> ENUM('TRUE','FALSE') DEFAULT FALSE' worked fine. I would like to have
something
> like bits or boolean values in my table. How to achieve this? Thanks for the
I use a TinyINT and store a 0 for FALSE and something other than 0 (like 1, or
whatever) for TRUE. That will only take 1 byte to store what you need.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
