You are not logged in. Your edit will be placed in a queue until it is peer reviewed.
We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.
Required fields*
- 2"He's removed them from existing tables to change things and it's caused data corruption [...] so he'd rather not use them." - I don't get it. The FKs were removed, the inevitable data corruption showed up and that's why he doesn't want to use them?user1822– user18222014-08-20 15:28:17 +00:00Commented Aug 20, 2014 at 15:28
- While the title question is legitimate, I think the idea behind it (proving you are right) and the way it is presented is a bit unoptimal. Nobody on this site will tell you that referential integrity is wrong and that you shouldn't use foreign keys. Also, it is not difficult to handle them, referential integrity can be disabled at any time in order to perform DMLs. I refuse to believe that your boss told you that they are plainly bad unless he has never used a database.jynus– jynus2014-08-20 15:30:49 +00:00Commented Aug 20, 2014 at 15:30
- Actually, the people that I have seen not using them for a custom developed application were either poor developers or had to implement them at application side because MySQL implementation was limited (too little constraints or extra locking).jynus– jynus2014-08-20 15:34:10 +00:00Commented Aug 20, 2014 at 15:34
- @a_horse_with_no_name Either he didn't explain his point properly, I misunderstood it or it's a flawed argument, but that's the impression I got as well. jynus I also refuse to believe that he told me they are bad (more that they are inconvenient), considering he's got more experience as a developer than I do.Agi Hammerthief– Agi Hammerthief2014-08-20 15:41:53 +00:00Commented Aug 20, 2014 at 15:41
- Interesting enough I never see this discussion when people are using Postgres, Oracle, DB2 or SQL Server. It's alyways MySQL where this discussion comes up.user1822– user18222014-08-20 15:43:32 +00:00Commented Aug 20, 2014 at 15:43
| Show 3 more comments
How to Edit
- Correct minor typos or mistakes
- Clarify meaning without changing it
- Add related resources or links
- Always respect the author’s intent
- Don’t use edits to reply to the author
How to Format
- create code fences with backticks ` or tildes ~ ```
like so
``` - add language identifier to highlight code ```python
def function(foo):
print(foo)
``` - put returns between paragraphs
- for linebreak add 2 spaces at end
- _italic_ or **bold**
- indent code by 4 spaces
- backtick escapes
`like _so_` - quote by placing > at start of line
- to make links (use https whenever possible) <https://example.com>[example](https://example.com)<a href="https://example.com">example</a>
How to Tag
A tag is a keyword or label that categorizes your question with other, similar questions. Choose one or more (up to 5) tags that will help answerers to find and interpret your question.
- complete the sentence: my question is about...
- use tags that describe things or concepts that are essential, not incidental to your question
- favor using existing popular tags
- read the descriptions that appear below the tag
If your question is primarily about a topic for which you can't find a tag:
- combine multiple words into single-words with hyphens (e.g. sql-server), up to a maximum of 35 characters
- creating new tags is a privilege; if you can't yet create a tag you need, then post this question without it, then ask the community to create it for you
lang-sql