MSSQL PRINT Like Function in MySQL Example

MySQL Function Example - MSSQL PRINT Like Function in MySQL

Open your MySQL Query Editor then copy & paste the below code to make a Function FN_PRINT which will server Like MSSQL PRINT in MySQL:

   DELIMITER |
   CREATE FUNCTION FN_PRINT ( InputString VARCHAR(500))  RETURNS VARCHAR(500)
   RETURN CONCAT('',InputString,'');
   |

MySQL Function Example - MSSQL PRINT Like Function in MySQL - MySQL Query Editor Output

Again open your MySQL Query Editor then copy & paste the below code to execute the Function to get the desired result:

   SELECT FN_PRINT(' i am like MSSQL PRINT. I can print max. 5000 character.') AS RESULT

MySQL Stored Procedure Example - Executing Stored Procedure - MySQL Query Editor Output

 

Related Tutorial Examples

  1. How to Find MySQL Stored Procedure or Function Information
  2. How To Find MySQL SERVER VERSION Information
  3. MySQL Stored Procedure: INSERT INTO SELECT... Example
  4. MySQL Stored Procedure: Variable Example
  5. MySQL Stored Procedure: Batch Salary Increment Example
  6. MySQL NULLIF() Function Number Value Example
  7. MySQL NULLIF() Function Boolean Value Example
  8. MySQL Sub-Query: INSERT INTO SELECT *... Example
  9. MySQL Sub-Query: CREATE TABLE SELECT... Example
  10. HTML Form Example in PHP

No comments:

Post a Comment

leave your comments here..