A function in MySQL is a stored programme into which you can pass parameters and get a value back.
A stored function and user-defined functions are created with the CREATE FUNCTION statement. A stored function is a collection of SQL statements that perform a single task and return a single result. It can be called from within a Mysql statement, just like the built-in function in MySQL.
String Functions. ASCII CHAR_LENGTH CHARACTER_LENGTH CONCAT CONCAT_WS FIELD FIND_IN_SET FORMAT INSERT INSTR LCASE.
Numeric/Math Functions. ABS ACOS ASIN ATAN ATAN2 AVG CEIL CEILING COS COT COUNT DEGREES.
Date/Time Functions.
Advanced Functions.
AVG, COUNT, SUM, MIN, DATE, and other functions can be used with select statements in SQL. Every time a function is called, it compiles. A value or result must be returned by functions. Only input parameters are used by functions. In functions, try and catch statements are not utilised.
Learner's Ratings
4.3
Overall Rating
64%
21%
7%
5%
3%
Reviews
R
Ravi Ranjan Tiwari
5
I am very happy that I am studying from LearnVern.
M
Muhammad Talha
5
help full.
P
Prince Bavishi
5
nice work
S
sonakshi Raj
4
Excellent
S
Shibu Kumari
5
Very Good
R
Rajiv Kumar Singh
4
It would have been better if you could have provided the resource/source_code files of the CRUD operations so that we could have cross verified our code with yours.
D
Dravinanshu Mishra
5
Excellent for Bigners.
A
Awais Khan
5
Thanks
M
Muhammad Arif jamal
5
This course is very helpful for me
S
Shital Kadam
5
Thank you, sir, for providing the best course on the internet.
Share a personalized message with your friends.