Rob Gravelle

Monday May 28th 2012 by DatabaseJournal.com Staff

Rob Gravelle's Database Journal articles.

Rob Gravelle

Rob Gravelle resides in Ottawa, Canada. His design company has built web applications for numerous businesses and government agencies. Email him.

Rob's alter-ego, "Blackjacques", is an accomplished guitar player, who has released several CDs and cover songs. His band, Ivory Knight, was rated as one of Canada's top hard rock and metal groups by Brave Words magazine (issue #92).


MySQL Crosstab Queries

Current Articles

- MySQL 8 Security Tips
- Top 10 Database Diagram Tools for MySQL
- Working with AUTO_INCREMENT Columns in MySQL
- Generate Dynamic MySQL Multi-row INSERT Statements
- Optimize MySQL Inserts Using Batch Processing
- A Guide to MySQL Prepared Statements and Parameterized Queries
- Managing Users and Roles in Oracle's MySQL Cloud
- Exploring Oracle's MySQL Cloud Service
- The Best (and Worst) Cloud Services for MySQL
- Displaying Leading and Trailing Whitespace on Varchar Columns in MySQL
- Top Reporting Tools for MySQL in 2018
- Monitor Your MySQL, MariaDB and Percona Servers with Navicat Monitor
- Web-based Database Management
- RDBMS Management on macOS
- Best New Features of MySQL 8
- Ransomware Attacks Against MySQL and How to Avoid Them
- Manage your Cloud MySQL Instance from Anywhere
- Configuring a MySQL Database on Amazon RDS
- Troubleshooting MySQL Performance Issues Using the Slow Log and Performance Schema
- Selecting WordPress Metadata
- Real-time MySQL Performance Monitoring
- Navicat 12: An Overview
- Speeding up MySQL Data Imports
- Implement a Secure WordPress Search
- Working with WordPress Result Sets
- Querying the WordPress Database
- Pivot Aggregate Counts on Months in MySQL
- Applying MySQL’s GROUP_CONCAT Function to Multiple Columns
- Why You Should be Using the MySQL GROUP_CONCAT Function
- Listing Duplicate Values by Group
- Top 6 MySQL DBA Mistakes
- Selecting the Top N Results by Group in MySQL
- Querying Multiple MySQL Tables
- MySQL Tuning for Large Datasets
- Calculating MySQL Database, Table, and Column Sizes
- Simplifying MySQL Database Design using a Graphical Data Modeling Tool
- In Search of a Regex Replace Function for MySQL
- MySQL Collaboration in the Cloud
- Searching on JSON Values in MySQL 7
- Working with JSON Data in MySQL 7
- Top 10 MySQL Reporting Tools
- MySQL Pattern Matching using Regular Expressions
- The Problem with Statistics
- Common MySQL Insert and Update Tasks and Their Solutions
- A Roundup of Popular MySQL Mobile Apps for Android
- MySQL Error Handling using the Signal and Resignal Statements
- Top 10 MySQL GUI Tools
- Exploring MySQL 5.7’s Geo-Spatial Functions
- Debugging MySQL Stored Procedures
- Building MySQL Crosstab and Subreports
- MySQL: Calculating Distance Based on Latitude and Longitude
- MySQL Union and Union All Operators Primer
- Generating Reports on MySQL Data
- MySQL Fuzzy Text Searching Using the SOUNDEX Function
- Guarding Your Data against Cyber Attacks
- MySQL Workbench 6.2 Performance Reporting
- An Overview of the MySQL Performance Schema
- Manage your MySQL Data on the Go with Navicat Cloud and iOS
- MySQL Goes Mobile: A Roundup of Popular MySQL Mobile Apps for iOS
- MySQL Date Gotchas
- MySQL Numeric Overflow Gotcha
- Importing Into MySQL from Other Databases
- How Safe is Cloud Storage?
- Importing XML, CSV, Text, and MS Excel Files into MySQL
- Enhance Your MySQL XML Import Procedures using Prepared Statements
- Importing XML Data into MySQL Tables Using a Stored Procedure
- Assigning Roles to MySQL Users
- Converting Between Data Types in MySQL
- Rounding Down, Bankers Rounding, and Random Rounding in MySQL
- Locating Instances of a Word or Expression within a MySQL Database
- DIY Number Rounding For MySQL
- Three Handy MySQL Numerical Functions
- Using the InnoDB Memcached Plugin with MySQL 5.6
- Perform Row Operations Using MySQL Cursors
- MySQL Cursors and Loops
- MySQL General Security Tips
- New Query Optimizer Features in MySQL 5.6
- All About the MySQL 5.5 LOAD XML INLINE Statement
- Performing Full-text Searches in MySQL 5.6
- Comparing SQL Server and MySQL Functions
- Mapping Data Types between MySQL and SQL Server
- Comparing TokuDB to MySQL 5.5 with InnoDB on Small Databases
- Challenging MySQL Trigger Operations Made Easy
- The Wonderful (and not so Wonderful) Things about MySQL Triggers
- A Case for (Occasional) Denormalization of MySQL Data
- Testing Your MySQL Stored Procedures with MyTAP
- Handling Slow Processes in MySQL
- Email Job Failures Report to DBA using PowerShell
- Restore Your MySQL Database from a Backup Using PowerShell
- Understanding the MySQL Information Schema Database
- Automate Database Backups with MySqlDump and PowerShell
- Create MySQL Databases and Tables from a PowerShell Script
- Automate MySQL Queries with PowerShell
- Running Commands Against Your MySQL Databases using PowerShell
- The Pros and Cons of MySQL Table Locking
- MySQL's User Privileges Model for Access Control
- How MySQL Protects Your Password
- Securing the MySQL Root Account
- Achieving Five Nines Availability Using Synchronous Cluster Replication for MySQL
- Database Buyer's Guide Conclusion: Which Database Is Best for You?

Mobile Site | Full Site