List number of different values in a table in MySQL code example

Example 1: DISTINCT SQL

SELECT DISTINCT column1, column1, ..... FROM TABLE
/*DISTINCT WILL NOT SELECT THE SAME VALUES IN SAME COLUMN*/

Example 2: query DISTINCT

SELECT DISTINCT Column_name FROM table_name;