MySQL foreign key to allow NULL?

by

You can solve this by allowing NULL in the foreign key column tblImageFlags.resolutionTypeID.

PS Bonus points to whomever tells me whether, in the case of databases, it’s “indexes” or “indices”.

The plural of index should be indexes.

According to “Modern American Usage” by Bryan A. Garner:

For ordinary purposes, indexes is
the preferable plural, not indices.
…
Indices, though less pretentious than fora or dogmata,
is pretentious nevertheless.
Some writers prefer indices in
technical contexts, as in mathematics
and the sciences. Though not the best
plural for index, indices is
permissible in the sense “indicators.”
…
Avoid the singular indice, a back-formation from the plural indices.

More Related Contents:

  1. MySQL InnoDB foreign key between different databases
  2. Meaning of “n:m” and “1:n” in database design
  3. Foreign key constraints: When to use ON UPDATE and ON DELETE
  4. Which DB technology is sued to solve the following search issue? [closed]
  5. MySQL Creating tables with Foreign Keys giving errno: 150
  6. MyISAM versus InnoDB [closed]
  7. Compare two MySQL databases [closed]
  8. How should I resolve –secure-file-priv in MySQL?
  9. How do I quickly rename a MySQL database (change schema name)?
  10. What does character set and collation mean exactly?
  11. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  12. Storing image in database directly or as base64 data?
  13. Implementation of Levenshtein distance for mysql/fuzzy search?
  14. What’s the difference between MyISAM and InnoDB? [duplicate]
  15. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  16. In SQL, is it OK for two tables to refer to each other?
  17. How to increase MySQL connections(max_connections)?
  18. MySql views performance [closed]
  19. When to use NULL in MySQL tables
  20. MySQL: LAST_INSERT_ID() returns 0
  21. Using reserved words in column names
  22. Proper database model for a user feedback system (an interesting case)
  23. MySQL Errno 150
  24. MySQL – Replace Character in Columns
  25. How to remove constraints from my MySQL table?
  26. What is the difference between SQL and MySQL? [closed]
  27. Replace null with 0 in MySQL
  28. mysql Failed to read auto-increment value from storage engine
  29. How to store data with dynamic number of attributes in a database
  30. MySQL Relationships

Leave a Comment