Databases Reference
In-Depth Information
Manipulating events
Events are related to a single database, which is why you see an Events slider on the
Structure page for the marc_book database. Activating it reveals the following panel:
Indeed, this is a recurring event. We can use the first icon to edit the event (which
will have the effect of deleting and recreating the event), and the second icon to
remove it.
Exporting
It's possible to generate event-related statements at the end of an SQL database
export file by selecting the Add CREATE PROCEDURE / FUNCTION / EVENT
option. Please remember that some events may have an expiration time. Hence, they
may have vanished between the time you create them and the time you attempt to
export them, unless the ON COMPLETION PRESERVE clause was used when creating
the event.
Summary
MySQL 5.0's new features helped the product to comply with standards. Even
though phpMyAdmin has limited support for these features (especially lacking a
syntax-oriented editor), it has a basic set of features to work with views, routines,
triggers, and information_schema . phpMyAdmin also supports MySQL 5.1
partitions and events.
The next chapter covers the use of the tracking feature that permits the recording of
changes made to a MySQL database via phpMyAdmin.
 
Search WWH ::




Custom Search