phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "曾柏棠" <zengbait...@qq.com>
Subject 回复: Can set default value for column in phoenix ?
Date Fri, 14 Jul 2017 08:08:13 GMT
Oh ,thanks! 




------------------ 原始邮件 ------------------
发件人: "Juvenn Woo";<machese@gmail.com>;
发送时间: 2017年7月14日(星期五) 下午3:39
收件人: "user"<user@phoenix.apache.org>; 

主题: Re: Can set default value for column in phoenix ?



                                      Hi Baitang,                 


Yes, you can, but only constant value at the moment. So literal value such as ‘string’,
0, 0.0 would work well, but CURRENT_TIME will not. (As far as I know.) 
                 

Best,
-- 
Juvenn Woo
Sent with Sparrow



                                   
On Friday, 14 July 2017 at 3:29 PM, 曾柏棠 wrote:
                                      hi all,
   Can set default value for column in phoenix ?
   for example :


CREATE TABLE api.hahah(
subscribe_time bigint not null  , 
hahha varchar default 'aaa',
CONSTRAINT pk PRIMARY KEY (subscribe_time)
)



Thanks !
Mime
View raw message