How to choose your MySQL encoding and collation
When you start using or creating a database, you generally start with the defaults options and fix ...
When you start using or creating a database, you generally start with the defaults options and fix ...
This article about MySQL SubQueries has a brief introduction with advantages and examples. MySQL su...
This article is all about MySQL UNION Operator and a guide on how to efficiently use this operator....
MySQL supports a number of SQL data types. These data types can be divided in several categories: n...
Before proceeding to know how to use MySQL CASE in where clause, be sure to be aware of what a MySQ...
Before using MySQL CASE to fetch different columns based on condition, i.e. using where clause to s...
MySQL CONCAT() functionMySQL CONCAT_WS() function MySQL CONCAT() function MySQL CONCAT() func...
To export MySQL database from command Line a set of commands need to be executed. Follow the steps ...
The CHAR and VARCHAR types are String Types in MySQL as they store string (or say text type) data. ...
To extend group_concat() limit in MySQL there are two methods, either using SQL command or by setti...