Skip to content

Instantly share code, notes, and snippets.

@DingWeizhe

DingWeizhe/r.md

Created July 26, 2017 10:56
Show Gist options
  • Save DingWeizhe/97c0ffd6469a05bc91f3f58d8889a31a to your computer and use it in GitHub Desktop.
Save DingWeizhe/97c0ffd6469a05bc91f3f58d8889a31a to your computer and use it in GitHub Desktop.
Download ZIP
Database Version
Raw
r.md 
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