Tag Archives: View

MySQL, available in both UNIX and Windows, is one of the most popular database tools. As the latest version of MySQL, the perfected newer version, MySQL 5.0, provides you with many new features in this popular open source database server. It is incredibly fast, reliable, and easy to use for developers.

WHAT ARE THE NEW FEATURES?

To summarize, it is very simple and easy that MySQL 5.0 has added 4 great new features – trigger, views, data dictionary, and stored procedures. But of course it is not enough to just say those 4 words to describe how outstanding the features are. So, let’s not waste more time and know nothing by getting more!

Trigger

A database trigger is procedural codes that can be executed automatically to respond certain events on database particular tables. It is able to restrict access to specific data, perform logging, or audit data modifications. For the triggers, there are “row triggers” or “statement triggers”.

Row triggers is the action for every row of a table while statement triggers only happens once per INSERT, UPDATE, or DELETE statement. And these statement triggers are those that MySQL Database support – INSERT Trigger, UPDATE Trigger, and DELETE Trigger.

Stored Procedures

Stored routines (procedures and functions) are supported in MySQL 5.0. A stored routine or stored procedures are the set of SQL statements that can be stored in the server. Once this has been done, You don’t need to keep re-issuing the individual statements. Instead, you can refer to the stored routine.

Stored routines require the proc table in the mysql database. This table is created during the MySQL 5.0 installation procedure. Once it is installed, users can refer back to any statements stored in the server without having to reissue again with this ability in MySQL 5.0.

Views

In database functionality, the views consist of accessible stored query as a composed virtual table of the result set of queries. And, it is not like some ordinary tables in relational databases, as views do not form the physical schema part.

Views that also include updatable views are available in MySQL Server 5.0. Views are stored queries that when invoked produce a result set. Here, in MySQL 5.0, the views act as a virtual table. You will find this useful for some queries.

Data Dictionary

Data dictionary, as you all may have known, is a centralized repository of information about data such as meaning, relationships to other data, origin, usage, and format. It is also recognized as meta data – the data of the data.

And as you know, this is one of the new additional features in MySQL 5.0 that contains document describing a database or collection of databases that you can access. Wonderful right.

Well, with these four additional features, you will find MySQL 5.0 as even more amazing database server that you  feel hard to resist or choose the other database servers.