Supported features ΒΆ
Currently phpMyAdmin can:
- create, browse, edit, and drop databases, tables, views, columns, and indexes
- display multiple results sets through stored procedures or queries
- create, copy, drop, rename and alter databases, tables, columns and indexes
- maintenance server, databases and tables, with proposals on server configuration
- execute, edit and bookmark any SQL-statement, even batch-queries
- load text files into tables
- create [1] and read dumps of tables
- export [1] data to various formats: CSV, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Microsoft Word 2000, and LATEX formats
- import data and MySQL structures from OpenDocument spreadsheets, as well as XML, CSV, and SQL files
- administer multiple servers
- add, edit, and remove MySQL user accounts and privileges
- check referential integrity in MyISAM tables
- using Query-by-example (QBE), create complex queries automatically connecting required tables
- create PDF graphics of your database layout
- search globally in a database or a subset of it
- transform stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
- track changes on databases, tables and views
- support InnoDB tables and foreign keys
- support mysqli, the improved MySQL extension see 1.17 Which Database versions does phpMyAdmin support?
- create, edit, call, export and drop stored procedures and functions
- create, edit, export and drop events and triggers
- communicate in 80 different languages