inSUBJECTS
Stored Function in mysql
MySQL Stored Function A stored function is a stored program that returns a single value. Basically specific code that performs specific operations and then returns a result. It is used to encapsulate common formulas or business rules. Reusable SQL statements or stored programs and reduce data inconsistencies. Different from a stored procedure.…
Read more
inSUBJECTS
MySQL Views
MySQL Views view is a named SQL query statement, stored in the database and considered as a virtual table . It is a subset of a database, based on a query that runs from one or more database tables. It can be used to save frequently used, complex queries. It contains select rows and columns fields from one or more tables in the database. Creat…
Read more
Social Plugin