Browsing category MySQL

MySQL – The GROUP_CONCAT() function

GROUP_CONCAT() function is used to concatenate column values into a single string. It is very useful if you would otherwise perform a lookup of many row and then concatenate them on the client end. For example if you query: mysql> SELECT Language FROM CountryLanguage WHERE CountryCode = ‘THA’; It outputs: Language Chinese Khmer Kuy Lao

MySQL – Choose exact numeric data type

When we use a relational database system, we should know some important things. Numeric data type is very essential for a table. Here I describe some important points of Numeric Data type in MySQL: MySQL has 9 numeric data types Integer:            TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT Floating Point:  FLOAT, DOUBLE Fixed Point:      DECIMAL Other:              BIT,