phpMyAdmin is an open source web-based utility written in PHP designed for easy administration of MySQL databases.
phpMyAdmin can manage a whole MySQL server as well as a single database and can drop databases, delete/edit/add fields, create/drop/alter tables, execute any SQL statement, create dumps of tables and databases, manage keys on fields, export/import CSV data and administrate multiple MySQL servers or one single database.
Product's homepage
Here are some key features of "phpMyAdmin":
· create and drop databases
· create, copy, drop, rename and alter tables
· do table maintenance
· delete, edit and add fields
· execute any SQL-statement, even batch-queries
· manage keys on fields
· load text files into tables
· create (*) and read dumps of tables
· export (*) data to CSV, XML and Latex formats
· administer multiple servers
· manage MySQL users 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 or ...
· support InnoDB tables and foreign keys (see FAQ 3.6)
· support mysqli, the improved MySQL extension (see FAQ 1.17)
· communicate in 47 different languages
What's New in This Release: [ read full changelog ]
· The Visualize GIS data feature was throwing a fatal error, and this was fixed.
View the original article here
No comments:
Post a Comment