Skip to content

Instantly share code, notes, and snippets.

@DingWeizhe
Created July 26, 2017 10:56
Database Version
Employee(EID)
Customer(CID, EID)
Log(CID, Timestamp)
Insert Employee (EID) VALUES (1);
Insert Employee (EID) VALUES (2);
Insert Customer (CID, EID) VALUES (1, 1);
Insert Log (CID, Timestamp) VALUES (1, NOW());
Update Customer Set EID = 2 WHERE CID = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment