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

No comments:

Post a Comment

leave your comments here..