Like this:

Building a solid, dependable database takes time and expertise. Here are ten of the worst MySQL mistakes:

1. Using MyISAM rather than InnoDB
2. Using PHP’s mysql functions
3. Not sanitizing user input
4. Not using UTF-8
5. Favoring PHP over SQL
6. Not optimizing your queries
7. Using the wrong data types
8. Using * in SELECT queries
9. Under- or over-indexing
10. Forgetting to back up
11. Bonus mistake: not considering other databases!

Read details here:
http://www.sitepoint.com/mysql-mistakes-php-developers/

Advertisement