MySQL strcmp() Function NULL Value Example

MySQL strcmp() Function NULL Value Example

Open your MySQL Query Editor then copy & paste the below code to get the value of strcmp() MySQL Function NULL Value Example:

   -- mysql strcmp() function compares exactly two values, NULL Value Example

   select strcmp(NULL, NULL), strcmp(NULL, 'test'), strcmp('test', NULL), strcmp(NULL, 10/0);

   -- The mysql strcmp() function returns 0 if  equals 
   -- mysql strcmp() function returns -1 if  is smaller than 
   -- The mysql strcmp() function returns 1 if  larger than 
   -- OR if the comparison returns a NULL
   -- mysql strcmp() function returns NULL if  or  is NULL

-- is comment in MySQL -- in fact it is comment in MSSQL and Oracle as well

MySQL strcmp() Function NULL Value Example - Result in MySQL Query Editor

 

Related Tutorial Examples

1. MySQL isnull() Function Example
2. MySQL strcmp() Function Number Value Example
3. MySQL strcmp() Function Example :: on Equals,Large.. Values
4. MySQL interval() Function Example
5. MySQL coalesce() Function Example
6. MySQL IF() Function Boolean Value Example
7. MSSQL PRINT Like Function in MySQL Example
8. How to Find MySQL Stored Procedure or Function Information
9. MySQL Sub-Query: INSERT INTO SELECT... Example
10. MySQL Sub-Query: INSERT INTO SELECT *... Example