Top 10 MySQL Mistakes Made By PHP Developers
- Using MyISAM rather than InnoDB
- Using PHP’s mysql functions
- Not sanitizing user input
- Not using UTF-8
- Favoring PHP over SQL
- Not optimizing your queries
- Using the wrong data types
- Using * in SELECT queries
- Under- or over-indexing
- Forgetting to back up
- Bonus mistake: not considering other databases!