phpMyAdmin offers features that cover basic MySQL database and table operations.
It also has an internal relational system that maintains metadata to support advanced
features. Finally, system administrators can manage users and privileges from
phpMyAdmin. It is important to note that phpMyAdmin's choice of available
operations depends on the rights the user has on a specific MySQL server.
Introducing phpMyAdmin
[ 14 ]
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.
Pages:
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37