Mysq中l建立测试父表、子表及测试用例归纳总结

select version();

5.7.22

drop table if exists Models;

CREATE TABLE Models

  (

    ModelID SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,

   Name VARCHAR(40) NOT NULL,

    PRIMARY KEY (ModelID)

);

drop table if exists Orders;

CREATE TABLE Orders

  (

    ID          SMALLINT UNSIGNED NOT NULL PRIMARY KEY,

   ModelID     SMALLINT UNSIGNED NOT NULL,

     Description VARCHAR(40),

    FOREIGN KEY (ModelID) REFERENCES Models (ModelID)

      ON DELETE cascade

  );

insert into Orders(Id,ModelID,Description) values (1,1,'a');

insert into Models(ModelID,Name) values (1,'a');

insert into Orders(Id,ModelID,Description) values (1,1,'a');

select * from Models;

1    a

select * from Orders;

1    1    a

delete from Orders where id = 1;

select * from Models;

1    a

select * from Orders;

为空

delete from Models where ModelID = 1;

select * from Models;

为空

select * from Orders;

为空

update Orders set ModelID = 3 where ID =1;

update Models set ModelID = 2 where ModelID =1;

update Orders set Description = 'b' where ID =1;

select * from Orders;

1    1    b

update Models set Name = 'c' where ModelID =1;

select * from Models;

1    c