List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:March 20 2002 2:36pm
Subject:Re: default value
View as plain text  

Michal Dvoracek wrote:

>Hello,
>
>s possible to create table with default value returned by built-in
>function ??
>like:
>
No.

>
>create table x (a int not null default UNIX_TIMESTAMP());
>
What is wrong with the timestamp field type?

>
>
>When inserting new column in table field a will contains timestamp?
>
>sql,query
>
>Regards,
>Michal Dvoracek                          michal.dvoracek@stripped
>
>
>---------------------------------------------------------------------
>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 <mysql-thread103565@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
default valueMichal Dvoracek20 Mar
  • Re: default valueGerald Clark20 Mar
  • Re: default valuedenonymous20 Mar