#清空某列 update {tablename} set {columnname} = null;
#增加一列 alter {tablename} add {columnname} varchar(20);
#删除一列 alter {tablename} drop column {columnname};
#删除一行 delete from {tablename}#全部删除 or add :where {columnname} = 'xx';
#按条件插入n条数据 insert into tem select id,name from sample;
#删除外键
#先删外键约束 alter table task drop foreign key ‘FK_Reference_7’; --用单引号
#再删外键列 alter table task drop column {columnname}; --列名不能用单引号
#增加一列 alter {tablename} add {columnname} varchar(20);
#删除一列 alter {tablename} drop column {columnname};
#删除一行 delete from {tablename}#全部删除 or add :where {columnname} = 'xx';
#按条件插入n条数据 insert into tem select id,name from sample;
#删除外键
#先删外键约束 alter table task drop foreign key ‘FK_Reference_7’; --用单引号
#再删外键列 alter table task drop column {columnname}; --列名不能用单引号