Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Arun Mahajan
- Order by date
-
How to catch SQL Exception Error number in MySQL 5.6
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...- Arun Mahajan
- Thread
- Replies: 0
- Forum: MySQL
-
Why this query is showing multiple result
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...- Arun Mahajan
- Thread
- Replies: 1
- Forum: MySQL
