Tagged: SQL
- Issue with SQLyog Job Agent on Ubuntu
- Using SQL's IN syntax to search multiple fields
- Setting up a secure MySQL server on Rackspace Cloud Servers
- Drain your InnoDB Buffer Pool by moving large fields out of MySQL
- Going Vanilla with MySQL
- How to Setup a LAMP Stack on Ubuntu 12.04 LTS
- How to Setup a LEMP Stack on Ubuntu 12.04 LTS
- PHP Session Handling
- SQLite as a PHP Session Handler
- How to Install the SQLite Module on Ubuntu 12.04 LTS
- MySQL and Redis Command Equivalents
- How to Connect to a Database with PHP Data Objects (PDO)
- How to Use Prepared Statements in PHP
- Using Transactions with PHP Data Objects (PDO)
- How to set up a LAMP server on Ubuntu 13.10
- Transactions with PHP Data Objects (PDO)
- Reducing Redis used memory by moving back to MySQL
- How to Setup a LAMP Stack on Ubuntu 14.04 LTS
- How to Setup a LEMP Stack on Ubuntu 14.04 LTS
- Stop Accommodating Shortcomings
- How to kill a query on Amazon Relational Database Service (RDS)
- Add column after another column in MySQL
- Using variables in MySQL queries
- Generating UUIDs with MySQL
- Schedule queries with MySQL
- How to Delete from a Table with Foreign Key Constraints in MySQL