MySQL 
 keyboard_arrow_down 295 guides
 chevron_leftNumeric
Method ABSMethod ACOSMethod ASINMethod ATANMethod ATAN2Method CEILMethod CEILINGMethod CONVMethod COSMethod COTMethod CRC32Method DEGREESMethod EXPMethod FLOORMethod LNMethod LOGMethod LOG10Method LOG2Method MODMethod PIMethod POWMethod POWERMethod RADIANSMethod RANDMethod ROUNDMethod SIGNMethod SINMethod SQRTMethod TANMethod TRUNCATE
  check_circle
 Mark as learned thumb_up
 0
 thumb_down
 0
 chat_bubble_outline
 0
 Comment  auto_stories Bi-column layout 
 settings
 MySQL | EXP method
 schedule Aug 11, 2023 
 Last updated  local_offer 
 Tags MySQL
  tocTable of Contents
 expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
   Start your free 7-days trial now!
MySQL's EXP(~) method returns the value of $e$ (base of natural logarithm) raised to the power of X .
Parameters
1. X | number
The power to apply.
NOTE
The mathematical constant $e$ is approximately equal to 2.71828
Return value
The value of $e$ raised to the power of X.
Examples
To return $e$ to the power 2:
        
        
            
                
                
                    SELECT EXP(2);
                
            
            +------------------+| EXP(2)           |+------------------+| 7.38905609893065 |+------------------+
        
    To return $e$ to the power -3:
        
        
            
                
                
                    SELECT EXP(-3);
                
            
            +----------------------+| EXP(-3)              |+----------------------+| 0.049787068367863944 |+----------------------+
        
    Published by Arthur Yanagisawa
 Edited by 0 others
 Did you find this page useful?
 thumb_up
 thumb_down
 Comment
 Citation
  Ask a question or leave a feedback...
 Official MySQL Documentation
                    https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html#function_exp
                 thumb_up
 0
 thumb_down
 0
 chat_bubble_outline
 0
 settings
 Enjoy our search
 Hit / to insta-search docs and recipes!
 