MySQL Archives - Fedingo

How to Check if Column is Empty or Null in MySQL

Sometimes you may need to check if column is empty or null in MySQL. Here are 3 different ways to check for null values in column.

Often you may need to remove leading & trailing whitespace from strings in MySQL. Here are the steps to do it.

Often you may need to convert string to date in MySQL. Here are the steps to do so.

Sometimes you may need to get row count for all tables in MySQL. Here are the steps to do so.

Sometimes you may get the error ‘Can’t Connect to Local MySQL Socket’ error while using MySQL. Here are the steps to fix this error.

MySQL string comparison is case insensitive. Here is how to make case sensitive case string comparison in MySQL.

Sometimes you may need to fix 2006 MySQL Server has gone away error. Here are the steps to do it.

Sometimes you may need to auto increment column with prefix in MySQL. Here are the steps to do so.

Sometimes you may need to set initial value and auto increment in MySQL. Here are the steps to do it.

Sometimes you may need to get column names from table in MySQL. Here are the steps to do it.