An Event is a scheduled job executed by the MySQL server itself. Events are supporoted from MySQL 5.1. If your MySQL version does not support events you should note that…
A Trigger is a piece of code that is executed in response to a data modification statement – that is, an insert, update, or delete – and usually ensures consistent behaviour of the database.…
Similar to stored procedures, user-defined Functions are physically stored within a database in compiled form under a certain name. This allows you to share the functions between a number of programs. The distinct…
A Stored Procedure (also a Stored Proc) is a sub-program which is physically stored within a database in compiled form under a certain name. This allows you to share the procedure between a…
SQLyog supports the use of ‘delimiter‘ statements. This is required in order to support Objects like Stored Procedures, Triggers etc. But the ‘delimiter’ statement need not be used in that context.…
A View is a virtual table based on the result-set of a SELECT statement. A view contains rows and columns, just like a real table. The fields in a view are fields…
With the term ‘Others’ we refer to all information that a database can contain that are not database Tables. Most objects do not contain DATA, but various types of code and ‘rules’…
