Articles about mysql.
If a tree falls in a woods with no one to hear, did it actually fall? Likewise, if a user submits a form but it is not persisted in some form, that form submission is worthless.
So, I ran into a "funny" sorting issue this week. Turns out there was a <TAB> in a product title, causing that title to be sorted first. (Quite logic if you look at the ASCII table.)
Turns out that running mysqldump against a database takes more than just SELECT permissions. Use this GRANT command to grant the necessary privileges for dumping a database.
I hadn't realized this until today: MySQL views can't have indexes!
I thought I was a pretty good database developer. I wouldn't call myself a DBA or a "guru", but I would have put myself in the upper 50%.