MySQL strcmp() Function Number Value Example

MySQL strcmp() Function Number Value Example

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

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

   select strcmp(22, 33), strcmp(33, 11), strcmp(0, 0), strcmp(-1, -2), strcmp(-1, -2/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 Number Value Example - Result in MySQL Query Editor

 

Related Tutorial Examples

1. MySQL isnull() Function Example
2. MySQL strcmp() Function NULL 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. MySQL Stored Procedure: Variable Example
8. MySQL Stored Procedure: Batch Salary Increment Example
9. Creating Database(s) using SQL Command MySQL Example
10. MySQL sample database script: Create Database using SQL Statement Example