Tag Archives: Mysql 5.0

Easter 2009, it’s time to re-joy as it is always each year! Feasting, family and friends gathering will be awesome for this holy occasion. Hunting easter eggs is also exciting and fun to do. Plus, remember to attend church to  celebrate this great day to really feel the important meaning behind this special day.

What Is It behind Easter Day?
Is it all about feasting and gathering? Well, of course not only that! Easter is appreciated as the time to celebrate the resurrection of Jesus Christ, celebrated on the third day after Christ died (Good Friday). Christians believe that after Christ was executed and He saved humans with the sacrifice of His blood, He resurrected on the third day after His death.

And the resurrection day of Him is commemorated as the Easter day, which falls on Sunday. This has become one of the important days of the Christian’s days and is celebrated every year.  This means you can’t say you are Christian if you do not celebrate this important day to memorize the greatness of Jesus Christ.

How Can We Celebrate Easter more besides Feasting, Gathering, and Egg Hunting?

There are always more stuffs to do. For example, what a special day is without gifts, especially on Easter? Use this special day to excite your beloved ones – friends, families, or co-workers – with amazing easter gifts and send your best mates gift baskets filled with Easter sweets, toys, games, and delicious chocolates (everybody loves it). When these baskets reach their doorsteps with your best sincere wishes to them, your friendship will be even more strengthened.

You can even complete Easter more terrificly by creating and writing beautiful and attractive Easter Cards to send to your friends, families, or lover. Yes! Easter Cards sound like just an old tradition but it is still lovely to send to show that we care. So, don’t miss out the cards.

If you feel you cannot write or create ones, these cards are available to purchase in the markets. Or, if you might want something practical, electronic cards are also a good option to send through email messages. With either of these cards, you can send best wishes of cheers, joys and happiness.

So, Welcome Easter!
Say no to skipping to celebrate Easter Day. Even we, Host Department, celebrates this very holy-day by giving out the gift for you. How? Currently, we are sharing discounts in all of our Shared Hosting plans as our Easter special gift for you.

Yep! Just by using our coupon code “EASTER09” (all should be written in CAPS), you can subscribe  either our outstanding and all new Premium Hosting or our unlimited growth No Limit hosting plans with 20% off. No other requirement!

With our Premium Hosting, you will get all you’ve been dreaming of an ideal web hosting – the latest web hosting technologies for both UNIX and Windows (PHP5, MySQL5, .NET 3.5, Ruby on Rails, MS-SQL 2005, AJAX Support, and many more), all new IBM Xseries Blade Servers with very high-speed performance, and quick fix customer support.

As there are so many ways to celebrate this very special day, let’s have our great and meaningful moment on Easter day.

~Gabrielle~

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.