Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Posted May 28, 2012

Rob Gravelle

By DatabaseJournal.com Staff

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?
Cloud Database Buying Guide
Database Buying Guide: Open Source Databases
IBM DB2 Database Buying Guide
Microsoft SQL Server Buying Guide
Oracle Database Buyer's Guide
Desktop Database Buying Guide
Database Buyer's Guide, Part 2: Features, Features, Features
Should You Move Your MySQL Database to the Cloud?
Beyond the LIKE Operator: Advanced Pattern Matching with MySQL
Three Ways to Identify Non-matching Records in MySQL
Database Buyer's Guide: Database Types and Features
Converting between MySQL Date and Time Formats
Using MySQL's Analysis Tools to Improve Query Performance
Identify Slow Queries using MySQL's Analysis Tools
Top 10 MySQL Best Practices
Writing Reusable Queries in MySQL
Limiting the Number of Rows in MySQL Result Sets
Optimizing MySQL Query Retrieval Speed Through Table Joins
Use Derived Tables in Your MySQL Queries to Improve Database Performance
Eliminating Duplicate Rows from MySQL Result Sets
Clearing a Path through the 3NF Join Jungle
Cardinality in MySQL Data Modeling
How Operator Precedence Affects MySQL SELECT Queries
Disambiguating between Duplicate Column Names in MySQL
Identifying and Eliminating the Dreaded Cartesian Product
MySQL SELECT Statement 101
Five Handy Tips for MySQL's Powerful UPDATE Statement
MySQL INSERT Statement Variations
MySQL Data Manipulation and Query Statements
Top 10 MySQL GUI Tools
Passing Field Names to MySQL Crosstab Stored Procedures
MySQL Input Parameters Add Flexibility to Crosstab Stored Procedures
MySQL Prepared Statements to Generate Crosstab SQL
MySql View Technique for Grouping Crosstab Column Data
MySQL CASE Statements in Multi-Aggregated Crosstab Columns
MySQL Multi-Aggregated Rows in Crosstab Queries
Tips for Simplifying Crosstab Query Statements
Harmonizing Character Encoding Between Imported Data and MySQL
All About the Crosstab Query
More Efficient and Readable Select Queries with MySQL Subqueries
XPath Support for Working with XML Data in MySQL
Data Formatting, Working with XML Data in MySQL
Working with XML Data in MySQL
Make Your MySQL Queries More Efficient with Temporary Tables
Maximizing Query Performance through Column Indexing in MySQL
Tips for Managing Complex Queries
Fetching Data from Multiple Tables using Joins
Running MySQL in Batch Mode
Enhance your Queries with Stored Functions
Creating Stored Procedures in MySQL Using HeidiSQL 4's Stored Routine Editor
Write SQL Code for MySQL Using HeidiSQL 4