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