Articles about mysql

2022

• Creating a ColdFusion UUID in MySQL
• Order by NULL Values in MySQL, Postgresql and SQL Server

2020

• Do you ¿ UTF-8? It's easier than you think

2019

• Communications link failure MySQL JDBC with TLS

2009

• Use MySQL? You need Maatkit

2008

• MySQL JDBC Load Balancing with MySQL Cluster
• Top 10 Reserved SQL Keywords
• INFORMATION_SCHEMA Support in MySQL, PostgreSQL

2007

• Amazon S3 Storage Engine for MySQL
• Calculating Distance in Miles from Latitude and Longitude
• Backwards LIKE Statements
• MySQL Optimization Hints

2006

• SELECT NULL Rows with MySQL
• Sphinx - Open Source SQL Full Text Search Engine
• Trick or Treat - Web 2.0 Goodies for ColdFusion
• MySQL Command Line Help
• Google Video: MySQL Performance Tuning Best Practices
• Updated SQL Reserved Words Checker
• Forta's MySQL Crash Course

2005

• Change size of a varchar column with mysql
• MySQL FULLTEXT Indexing and Searching
• MySQL Access Denied error 1044
• SQL to Select a random row from a database table
• Cheat Sheet Roundup - Over 30 Cheatsheets for developers
• SQL Pagination with LIMIT and OFFSET
• MySQL ERROR 1016 (HY000): Can't open file
• MySQL DELAY_KEY_WRITE Option
• Insert Delayed with MySQL
• The MySQL Query Cache
• Performance of database tag schemas
• Multiple Inserts with MySQL
• Multiple Statements with MySQL and JDBC
• Prepared Statements in PHP and MySQL
• High Performance MySQL
• SQL Reserved Key Words Checker Tool
• Triggers in MySQL 5

2004

• MySQL Popular among ColdFusion Developers

2003

• Returning TOP N Records

Pete has written about mysql a total of 38 times. In articles about mysql, Pete also often writes about: sql, databases, postgresql, performance, and sqlserver.