This function is used to create a delay, where numeric_exp represents the number of milliseconds to wait.
 

Example:

SELECT cnxsleep(5000) from customers
 

This example creates a pause of 5 seconds for every record in the customers_rms table.