Freeze the table DROPTABLEIFEXISTS 'froze _ info'; CREATETABLE 'froze _ info' ('id' int (11) NOTNULLAUTO_INCREMENTCOMMENT & #39; Id & #39 ;, 'proid' varchar (36) NOTNULLCOMMENT & #39; bidding project ID & #39;, 'companyid' varchar (36) NOTNULLCOMMENT & #39; user ID & #39 ;, 'userid' v mysql Query statement data database oracle
Freeze and unfreeze a table
DROP TABLE IF EXISTSfroze_info;
CREATE TABLEfroze_info(
IdInt (11) not null AUTO_INCREMENT COMMENT 'id ',
ProIdVarchar (36) not null comment 'bidding project identifi ',
CompanyIdVarchar (36) not null comment 'user ID ',
UserIdVarchar (36) default null comment 'authorization representative ',
AmtDecimal () not null comment 'ant ',
FlagChar (1) not null comment 'Operation identifi ',
SrcActVarchar (36) not null comment 'source account ',
DstActVarchar (36) not null comment 'Destination account ',
CreateDateVarchar (19) not null comment 'creation time ',
RunningNumVarchar (36) not null,
Primary key (Id)
) ENGINE = MyISAM AUTO_INCREMENT = 100006 default charset = utf8 COMMENT = 'freeze and unfreeze information ';
WhereProId,CompanyId,UserId,Flag'
The four fields are unique.Flag' is frozen and restored
How can I find unfrozen data?