Phpmyadmin 简明教程

phpMyAdmin - Features

以下是 phpMyAdmin 的一些主要功能。

Following is some of the key features of phpMyAdmin.

  1. User friendly Web Interface − phpMyAdmin UI is quite intuitive and easy to use.

  2. Most of Database Operations are supported − phpMyAdmin supports most of the MySQL/MariaDB features as listed below − Browse databases, tables, view, fields and indexes. Create/Copy/Drop/Rename databases, tables, view, fields and indexes. Server maintenance, database/tables configuration proposal. Execute, Edit and bookmark SQL statements, batch queries. Manage user accounts and privilleges. Manage stored procedures and triggers.

  3. Import Data − Data can be imported from from CSV and SQL files.

  4. Export Data − Data can be exported to various formats like CSV, SQL, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, LATEX and others

  5. Multiserver support − phpMyAdmin can be used to administrater multiple servers together.

  6. Graphics Support − phpMyAdmin can show graphics of database layout in various formats.

  7. Query-by-example − phpMyAdmin Query-by-example (QBE) can be used to create complex queries.

  8. Search − phpMyAdmin allows to searching globally in a database or a subset of database.

  9. Transformation − phpMyAdmin can help in transforming stored data into any format using a set of built-in functions, for example displaying BLOB-data as image or download-link.