Advertisement
Guest User

Untitled

a guest
Feb 20th, 2018
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. SQL query:
  2.  
  3. CREATE TABLE Customers (
  4. CustomerId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  5. Name VARCHAR(255) NOT NULL,
  6. Album VARCHAR(255) NOT NULL,
  7. Copies INTEGER,
  8. PRIMARY KEY (CustomerId),
  9. CONSTRAINT FKC1
  10. FOREIGN KEY FKalbum (Album)
  11. REFERENCES Discs (DiscID)
  12. ON DELETE CASCADE
  13. ON UPDATE CASCADE
  14. )
  15.  
  16. MySQL said: Documentation
  17. #1005 - Can't create table `store`.`customers` (errno: 150 "Foreign key constraint is incorrectly formed") (Details…)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement