Get the Column Default Value in MySQL Database

Hello Andrea, sorry but it is not what I am looking for

Please refer below script

SELECT COLUMN_DEFAULT AS DefaultValue 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME='TableName' 
AND COLUMN_NAME = 'ColumnName'