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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Posted May 28, 2012

Rob Gravelle

By DatabaseJournal.com Staff

Rob Gravelle resides in Ottawa, Canada, and is the founder of GravelleConsulting.com. Rob has built systems for Intelligence-related organizations such as Canada Border Services, CSIS as well as for numerous commercial businesses. EmailRob to receive a free estimate on your software project. Should you hire Rob and his firm, you'll receive 15% off for mentioning that you heard about it here!

In his spare time, Rob has become an accomplished guitar player, and has released several CDs. His former band, Ivory Knight, was rated as one Canada's top hard rock and metal groups by Brave Words magazine (issue #92).

Rob uses and recommends MochaHost, which provides Web Hosting at $3.10 per month, 2 LifeTime Free Domains, and 6 Months Free!

Series

MySQL Crosstab Queries

Current Articles

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



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.