MySQL Forums
Forum List  »  Stored Procedures

Re: UUID column type
Posted by: Roland Bouman
Date: November 04, 2005 09:22AM

I don't think so, although it would be cool. The only 'function' that I know of that you can use in a default declaration is the CURRENT_TIMESTAMP function for TIMESTAMP columns, see: http://dev.mysql.com/doc/refman/5.0/en/create-table.html

-->
The DEFAULT clause specifies a default value for a column. With one exception, the default value must be a constant; it cannot be a function or an expression. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE. The exception is that you can specify CURRENT_TIMESTAMP as the default for a TIMESTAMP column. See Section 11.3.1.1, “TIMESTAMP Properties as of MySQL 4.1”.
<--

Options: ReplyQuote


Subject
Views
Written By
Posted
65933
October 16, 2005 10:15AM
28911
October 18, 2005 09:03AM
21797
October 18, 2005 07:47PM
27844
October 19, 2005 07:28AM
18613
October 28, 2005 03:58AM
17159
September 08, 2007 03:46PM
Re: UUID column type
15702
November 04, 2005 09:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.