Databases Reference
In-Depth Information
The basic features consist of:
•
•
•
•
•
•
•
•
•
•
•
•
•
Database creation, deletion, renaming, and attribute change
Table creation, renaming, copying, and deletion
Table structure maintenance, including indexes
Special table operations (repair, optimization, changing type)
Data insertion, modification, deletion
Data display in horizontal/vertical mode, and Print view
Data navigation and sorting
Binary data uploading
Data search (table or database)
Querying by example (multi-table)
Batch-loading of data (import)
Exporting structure and data in various formats, with compression
Multi-user and multi-server installation with web-based setup
The advanced features include:
•
•
•
•
•
•
•
•
Field-level comments
Foreign keys (with or without InnoDB)
Browse foreign table
Bookmarks of queries
Data dictionary
PDF relational schema and dictionary
SQL queries history
Connection to MySQL using either the traditional
mysql
extension or the
new
mysqli
extension (in PHP 5)
Character-set support for databases, tables, and fields (with MySQL 4.1)
Column contents transformation based on MIME type
Visual Designer for relations
Support for MySQL 5.0 features: views, procedures, triggers, profiling
Theme management to customize the interface's look
•
•
•
•
•
Search WWH ::
Custom Search