sql | 100Utils

Stored Function

Posted By: Krish Johnsonon: April 17, 2018In: TutorialsTags: database, mysql, sql, stored functionNo Comments

A stored function is a special kind stored program that returns a single value. You use stored functions to encapsulate common formulas or business rules that are reusable among SQL statemen... Read more

MySQL Data Types

Posted By: Krish Johnsonon: April 17, 2018In: TutorialsTags: data type, database, mysql, sqlNo Comments

A database table contains multiple columns with specific data types such as numeric or string. MySQL provides more data types other than just numeric or string. Each data type in MySQL can b... Read more

Stored Procedure

Posted By: Krish Johnsonon: April 17, 2018In: TutorialsTags: database, mysql, sql, stored procedureNo Comments

A stored procedure is a subroutine available to connected relational database system applications. A stored procedure is a set of Structured Query Language (SQL) statements with an assigned... Read more