How to create relationships in MySQL

by

If the tables are innodb you can create it like this: 

CREATE TABLE accounts(
    account_id INT NOT NULL AUTO_INCREMENT,
    customer_id INT( 4 ) NOT NULL ,
    account_type ENUM( 'savings', 'credit' ) NOT NULL,
    balance FLOAT( 9 ) NOT NULL,
    PRIMARY KEY ( account_id ), 
    FOREIGN KEY (customer_id) REFERENCES customers(customer_id) 
) ENGINE=INNODB;

You have to specify that the tables are innodb because myisam engine doesn’t support foreign key. Look here for more info.

More Related Contents:

  1. MySQL Cannot Add Foreign Key Constraint
  2. Required to join 2 tables with their FKs in a 3rd table
  3. Can a foreign key reference a non-unique index?
  4. SQL: Creating a Relational table with 2 different auto_increment
  5. MySQL – Conditional Foreign Key Constraints
  6. How do I use on delete cascade in mysql?
  7. Is it possible to reference one column as multiple foreign keys?
  8. MySQL query, MAX() + GROUP BY
  9. Foreign key constraints: When to use ON UPDATE and ON DELETE
  10. How to store a one to many relation in MySQL database?
  11. i have an error which i dont understand. can you help me? [closed]
  12. In SQL Server how to get the count of child if both parent and child are available [closed]
  13. MySQL select 10 random rows from 600K rows fast
  14. Get a list of dates between two dates
  15. Calculate a running total in MySQL
  16. Simulate lag function in MySQL
  17. Get record counts for all tables in MySQL database
  18. How do I check if a column is empty or null in MySQL?
  19. Use MySQL spatial extensions to select points inside circle
  20. INSERT … ON DUPLICATE KEY (do nothing)
  21. Deleting duplicate rows from a table
  22. Modeling Product Variants
  23. MySQL LIKE query with underscore
  24. Compare only day and month with date field in mysql
  25. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  26. What is the difference between SQL and MySQL? [closed]
  27. how to use a like with a join in sql?
  28. Strip last two characters of a column in MySQL
  29. What happens when I exhaust a bigint generated key? How to handle it?
  30. is there a length limit to group_concat or another reason why it would not work on a text field

Leave a Comment