TIL: MySQL best practices
I’ve been watching the excellent MySQL for Developers course, and the name is accurate. I took a SQL course in college, used SQL here and there professionally, but never really learned more than the basics. This course is great intermediate next step. The following are some things I found especially helpful. Schema Use the data type that reflects what you are modeling, use Date for dates, use Decimal for exact values....