Adminer offers both relative and absolute modifications.įor example, to fix typos on ten rows: You have to select these rows in phpMyAdmin, edit them, find the typos again and save. There is no way to change a field value for several rows at once in phpMyAdmin. To link data through foreign keys, you have to create an extra table and specify it in the configuration of phpMyAdmin. It is possible to download the contents of a blob field in phpMyAdmin only by creating extra tables, specifying them in the configuration and manually marking the downloadable fields. It is also possible to order by several columns at once. Adminer offers a friendly interface.Īdminer allows grouping results and applying functions to columns in select statements. PhpMyAdmin does not offer an interface for creating these objects and has only primitive functionality for altering them.Ĭalling stored procedures and functions in phpMyAdmin is possible only by creating a SQL query. Half of users do not know that it has a different function than table name, the other half is not sure which function it is. It is not possible to alter a view in phpMyAdmin, it must be dropped and recreated manually.Īn example that applies to many differenet cases: there is an icon by table name in navigation. Adminer offers a foreign keys interface directly in create/alter table. You have to create an index manually before you create the foreign key. It is not possible to create multi-column foreign keys in phpMyAdmin. Adminer allows manipulation with all indexes together. Adminer can reorganize columns and add them in different places - at once.Īdminer offers textarea with one item per line for enum type creation.Īdding an index is a slow operation with big tables. PhpMyAdmin cannot move columns and cannot add columns in different places at once (every alter table is very slow when applied to big tables). The form design transposes based on the number of fields. In phpMyAdmin you have to specify the number of fields prior to creating the table. MySQL, SQLite, PostgreSQL, MS SQL, OracleĪdminer is also available in a MySQL-only version.Īdminer offers permanent login including user list, phpMyAdmin only partial support through configuration. I do not have enough energy to do a similar in-depth comparison with current versions. This comparison was made in the past and the current state might be different. There are several screenshots linked from the comparison table further explaining the difference. In which areas is Adminer a better alternative to replace phpMyAdmin? The list is quite long and some points may be insignificant for you. However, it is not perfect which is the reason why Adminer has been created. PhpMyAdmin is one of the most famous tools for managing the MySQL database.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |