MySQL CREATE FUNCTION, DELIMITER.DROP FUNCTION,built-in functions

Published: 08 January 2023
on channel: spa it

built-in functions
USE base2
SELECT COUNT(Phone) FROM Customers;
SELECT CONV(15,10,16);

DELIMITER

DELIMITER //

USE base2

SELECT * FROM Customers //
DELIMITER ;
CREATE FUNCTION
**************************************************************
**************************************************************

USE base2;

DELIMITER $$
CREATE FUNCTION F_minus (x1 decimal, y1 decimal)
RETURNS decimal (5,2)
DETERMINISTIC
BEGIN
DECLARE dist decimal;
SET dist = x1 - y1;
RETURN dist;
END$$
DELIMITER ;

SELECT F_minus(100,1);

DROP FUNCTION F_minus;

On this page of the site you can watch the video online MySQL CREATE FUNCTION, DELIMITER.DROP FUNCTION,built-in functions with a duration of hours minute second in good quality, which was uploaded by the user spa it 08 January 2023, share the link with friends and acquaintances, this video has already been watched 81 times on youtube and it was liked by 8 viewers. Enjoy your viewing!

318