Elby, > I want to construct a table, and in this table I have a column (date type) > that if I insert blank date, the MySQL automaticly insert the current date > of system.
You can use a TIMESTAMP column for this. If you insert NULL (or even nothing at all) it will be set to the current date and time. If you only want to see the current date, you can use DATE_FORMAT() when you select the record(s). The TIMESTAMP will also be set to the current date and time when you UPDATE the record. For details, see: http://www.mysql.com/doc/en/DATETIME.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Elby Vaz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 6:48 PM Subject: [ current date ] > hello people, > > I want to construct a table, and in this table I have a column (date type) > that if I insert blank date, the MySQL automaticly insert the current date > of system. > How do I do it? > > Thanks, > Elby. > > > > > > _________________________________________________________________ > MSN Messenger: converse com os seus amigos online. > http://messenger.msn.com.br > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
