Exhaustive look about optimizing queries for MySQL
http://mysql.rjweb.org/doc.php/index_cookbook_mysql
Ty's recommended SQL book
https://www.murach.com/shop-books/dat...oks/murach-s-mysql-3rd-edition-detail
An interesting utility that lets you run SQL queries against flat files (CSV, DSV).
http://harelba.github.io/q
Allow a re-import of a MySQLdump file
http://stackoverflow.com/questions/24...ile-that-doesnt-enforce-foreign-key-c
Another reason to hate Microsoft, SQL Server, and anyone associated with the previous two.
http://sqlnerd.blogspot.com/2006/07/memory-use-in-sql-server.html
Python library that allows you to query a CSV file with SQL.
https://github.com/harelba/q
PHP ORM that supports MS SQL.
http://www.doctrine-project.org
Data types in SQL Server
http://msdn.microsoft.com/en-us/libra...?PHPSESSID=tn8k5p1s508cop8gr43e1f34d2
PHP-based, SQLite CMS (with a self-explanatory name, really).
http://phpsqlitecms.net
-
http://www.owasp.org/index.php/SQL_Injection_Prevention_Cheat_Sheet