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
(
Id
Int (11) not null AUTO_INCREMENT COMMENT 'id ',
ProId
Varchar (36) not null comment 'bidding project identifi ',
CompanyId
Varchar (36) not null comment 'user ID ',
UserId
Varchar (36) default null comment 'authorization representative ',
Amt
Decimal () not null comment 'ant ',
Flag
Char (1) not null comment 'Operation identifi ',
SrcAct
Varchar (36) not null comment 'source account ',
DstAct
Varchar (36) not null comment 'Destination account ',
CreateDate
Varchar (19) not null comment 'creation time ',
RunningNum
Varchar (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?