Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 1 year ago. Improve this question How many digits can latitude and longitude have, before the decimal, and after the decimal? Here is an example I … Read more
Can anyone explain how to implement one-to-one, one-to-many and many-to-many relationships while designing tables with some examples? 4 Answers 4
I’m creating a database table and I don’t have a logical primary key assigned to it. Should each and every table have a primary key? 16 Answers 16
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed 5 months ago. The community reviewed whether to reopen this question 5 months ago and left it closed: Original close reason(s) were … Read more
Imagine a web form with a set of check boxes (any or all of them can be selected). I chose to save them in a comma separated list of values stored in one column of the database table. Now, I know that the correct solution would be to create a second table and properly normalize … Read more
Can I have multiple primary keys in a single table? 12 Answers 12
Bearing in mind that I’ll be performing calculations on lat / long pairs, what datatype is best suited for use with a MySQL database? 21 Answers 21 Basically it depends on the precision you need for your locations. Using DOUBLE you’ll have a 3.5nm precision. DECIMAL(8,6)/(9,6) goes down to 16cm. FLOAT is 1.7m… This very … Read more
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for … Read more
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 5 years ago. Improve this question I am evaluating what might be the best migration option. Currently, I am on a sharded MySQL (horizontal partition), … Read more
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 5 years ago. Improve this question I am evaluating what might be the best migration option. Currently, I am on a sharded MySQL (horizontal partition), … Read more
