FilesExpand file tree

main

/

18. Functions.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

23 lines (19 loc) · 705 Bytes

main

/

18. Functions.sql

Copy path

Top

File metadata and controls

• Code
• Blame

23 lines (19 loc) · 705 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

use ecom;

-- FUNCTIONS

-- Functions are basically the transformations. ie, what if we want to do something that is not available in sql, but we know the custom logic for it.

-- Then we can create our own function similar to UPPPER, AVG etc.

-- We can think functions like customized transformations.

-- Defenition: Functions in MySQL are predefined or user-defined routines that perform operations on data and reurrn a single value. They are very useful for manipulating data, performing calculations and symplifying queries.

delimiter //

create function square_it(x int)

returns int

deterministic

begin

return x*x;

end //

delimiter ;

select

unit_price,

square_it(unit_price)

from

dim_product;