SQL Server 里面创建计算列式的写法:[vday] AS (datepart(day,[add_time])),CREATE TABLE [dbo].[View_tb](
[l_id] [bigint] NOT NULL,
[default_time] [datetime] NULL,
[add_time] [datetime] NULL,
[vyear] AS (datepart(year,[add_time])),
[vmonth] AS (datepart(month,[add_time])),
[vday] AS (datepart(day,[add_time])),
[vhour] AS (datepart(hour,[add_time]))
) 不知道MySQl里面怎么写?
[l_id] [bigint] NOT NULL,
[default_time] [datetime] NULL,
[add_time] [datetime] NULL,
[vyear] AS (datepart(year,[add_time])),
[vmonth] AS (datepart(month,[add_time])),
[vday] AS (datepart(day,[add_time])),
[vhour] AS (datepart(hour,[add_time]))
) 不知道MySQl里面怎么写?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货