Good morning, we are in the process of rolling out MySQL 5.1 to all of our managed servers, you will recieve a notifiction informing you of the scheduled maintenance for your account this week, please be on the lookout!
Besides stability with MySQL 5.1 they have included some very key features for the developer at heart. If you have any concerns, feel free to contact our support team and we’ll be happy to discuss it with you.
For our Developers, the three biggest new features for customers in our cPanel environment are listed below:
A view is an alternative way to retrieve data from one or more tables. View is something like a filter that passes data from tables before user can see them. When user creates a view, data from tables are not duplicated. All view’s data are stored in tables from which the view is created. Work with views is the same as work with ordinary tables.
A trigger is a stored procedure that is associated with a table and that activates when a user tries to insert, update or delete data into/from table.
Events are tasks that run according to a beforehand defined schedule. When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time.
If you have any questions, please post in the comments or open a support ticket. Again thanks for your continued business and support!