Hi,
I have a MYSQL 5.6 version. In this version I want to capture the SQL Exception Error number and Error message.
In higher version you can use
GET DIAGNOSTICS CONDITION 1
And it works very well.
But for older version, I am failed to capture the Error Number.
Can you please help me do...
Why the following query gives multiple rows
SELECT
IF(ISNULL(trim(insured_ecard_path)), 'NULL', 'NOT NULL') as value,
COUNT(*)
FROM hrms_medical_gmc
where cmpcode='AT161'
GROUP BY insured_ecard_path
NOT NULL
4
NOT NULL
4
NOT NULL
4
NOT NULL
3
NOT NULL
5
NOT NULL
4
NOT NULL
6
NOT...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.