使用IFNOTEXISTS创建数据表

create table  sales3 ( id NUMERIC,sale_date datetime not null) 
PARTITION by range(TO_DAYS(sale_date))
(
   PARTITION sales20140301 values less than(TO_DAYS('2014-03-01')),
   PARTITION sales20140401 values less than(TO_DAYS('2014-04-01'))
)

[SQL] create table  sales3 ( id NUMERIC,sale_date datetime not null) 
PARTITION by range(TO_DAYS(sale_date))
(
   PARTITION sales20140301 values less than(TO_DAYS('2014-03-01')),
   PARTITION sales20140401 values less than(TO_DAYS('2014-04-01'))
)

[Err] 1050 - Table 'sales3' already exists

create table IF NOT EXISTS  sales3 ( id NUMERIC,sale_date datetime not null) 
PARTITION by range(TO_DAYS(sale_date))
(
   PARTITION sales20140301 values less than(TO_DAYS('2014-03-01')),
   PARTITION sales20140401 values less than(TO_DAYS('2014-04-01'))
)

[SQL] create table  if not exists sales3 ( id NUMERIC,sale_date datetime not null) 
PARTITION by range(TO_DAYS(sale_date))
(
   PARTITION sales20140301 values less than(TO_DAYS('2014-03-01')),
   PARTITION sales20140401 values less than(TO_DAYS('2014-04-01'))
)

受影响的行: 0
时间: 0.003ms