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.2
Overall Rating
63%
21%
7%
5%
4%
Reviews
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.
D
Dibyadarshini Das
4
I'm getting a fatal error insted of warning and also it's not showing the if condition statement.
Share a personalized message with your friends.