Unique key constraint mysql/maria internal error message

swiftinitpvtltd

WE have a unique key constraint on database table(safest approach to avoid duplicates) but when aware tries to add a record with duplicate directly shows database unique constraint error message. How do we modify this database message to make it user friendly? (shows Internal error- "error adding reference duplicate entry"

Constraint on a table-
ALTER TABLE table_name
ADD CONSTRAINT constraint_name UNIQUE KEY(column_1,column_2,...);

swiftinitpvtltd

How do we do below in aware?
https://stackoverflow.com/questions/10202818/can-you-customize-a-mysql-error-duplicate-error-message

$result = mysql_query('... query that produces duplicate key error ...');
if ($result === FALSE) {
if (mysql_errno() == 1022) {
die("Username already exists");
} else {
die(mysql_error());
}
}