MySQL has two concatenation functions, CONCAT and CONCAT_WS. I show how each one works and why CONCAT_WS makes adding a separator easier.
MySQL – Introduction to User Defined Variables
MySQL user defined variables let you store a value and use it later in your query, with no data type to declare. Here is how to set and read them.
MySQL – Beginning Temporary Tables in MySQL
MySQL temporary tables hold result sets for one connection and are dropped when it closes. Here is how to create them and why INFORMATION_SCHEMA skips them.
Great Indian Developers Summit 2014: Four Sessions
I presented four sessions at the Great Indian Developers Summit 2014 in Bangalore, and the rooms were standing room only. This post has my photographs from the event and the abstract of each session.
MySQL – How to Create Stored Procedure in MySQL
MySQL supports stored procedures for your business logic. Here is how to create a stored procedure in MySQL and execute it, with a simple sales example.
MySQL Habits That Trip Up Developers Moving to SQL Server
Replace six MySQL habits with SQL Server equivalents for LIMIT, AUTO_INCREMENT, quoting, GROUP BY, duplicate inserts, and collations.
MySQL – Finding First day and Last day of a Month
MySQL has LAST_DAY to find the last day of a month but nothing built in for the first day. I show two simple methods to find the first day as well.