MySQL 在新增表格时
create table t_active
(
ActiveId int not null auto_increment,
ActiveName varchar(100) not null,
UnitName varchar(200) not null,
BeginTime varchar(50) not null,
EndTime varchar(50) not null,
ActiveAddress varchar(200) not null,
ActiveType int not null,
UseFlag int not null,
Note longtext not null,
ImgUrl varchar(50) not null,
GroupOriented varchar(200),
RegReference varchar(200),
AddOperId int not null,
AddTime datetime not null,
ModifyOperId int,
ModifyTime datetime,
RewardTime int not null,
IsHadBalance int not null comment '1:未结算 2:已结算',
primary key (ActiveId)
);
出现[Err] 1050 - Table 't_active' already exists异常时
在create后面添加if not exists 即可避免!!!
create table if not exists t_active
(
ActiveId int not null auto_increment,
ActiveName varchar(100) not null,
UnitName varchar(200) not null,
BeginTime varchar(50) not null,
EndTime varchar(50) not null,
ActiveAddress varchar(200) not null,
ActiveType int not null,
UseFlag int not null,
Note longtext not null,
ImgUrl varchar(50) not null,
GroupOriented varchar(200),
RegReference varchar(200),
AddOperId int not null,
AddTime datetime not null,
ModifyOperId int,
ModifyTime datetime,
RewardTime int not null,
IsHadBalance int not null comment '1:未结算 2:已结算',
primary key (ActiveId)
);
亲测,已成功!!
错误原因:重复创建表格。
解决办法:不要执行上述错误代码;如有修改,删除表格,重新创建!