Currently there are many software that can be used to manage database data in MySQL, one of which is phpMyAdmіn. Using phpMyAdmіn, that means that one can easily create databases, tables, and input data, without having to worry about the line of command. As we can see, phpMyAdmіn is a pretty good application for managing MySQL databases. This software really helps us in managing web site data bases easily thanks to the user interface that we like.
Features in phpMyAdmіn
Following are some of the capabilities why phpMyAdmіn is widely used by many people:
- phpMyAdmіn is an easy-to-use and easy-to-understand interface. So, people can understand and be familiar with the phpMyAdmіn feature.
- phpMyAdmіn allows users to operate many MySQL services, such as managing data bases, operating MySQL queries, performing MySQL statements, managing users or inzіn.
- We can also receive and send data in various types of formats.
- Using the predefined functions, you can change the format of the data you have stored
- phpMyAdmіn allows us to build graphical data bases in PDF format, and complete multiple requests along with query-by-example.
- find the database precisely and quickly
Manage Databases with phpMyAdmin
We certainly understand that phpMyAdmin’s function is to manage databases. Following are the benefits of phpMyAdmin in helping us manage our database. When using the phpMyAdmin application, specify the database which you will manage on the left side of the screen. In the active window, you will be presented with several database tables, allowed actions, storage medium, number of records, checks, table size and overhead. Management that can be done in managing the database is:
In a table that uses records and records that we have access to. After you click Browse, a new page with a list of records in the table opens. If you want to change one of the existing records, you can click the Edit button. We will display the record structure and replace the record values. After completing the changes, you can also share by clicking the Open button at the bottom of the page.
On pressing the New page structure symbol showing the database structure will open. We will be presented with the field name, collection, type, attribute, information, default value or information on whether the value of this field can be NULL. We can also get different values by pressing the management symbol that matches our expectations. Also, we can change the structure or delete fields. We can also define different indexes such as Unique, Index, Main or Full Text.
By using the Lookup button, you can create a lookup query for the table you want. We can use the Query by example function to find a table. Just use the various fields to compile your search query and hit the Go symbol to operate it. If we want to describe all records with field values starting with the alphabet “C” we must first determine which fields we want to display. Then press the LIKE operator from the drop-down menu and enter the appropriate field value “C%” (% stands for wildcard string). Press the Go icon to display the results.
By using the Insert icon, you can insert records in a database table. Next we enter the appropriate click value on the Go icon and the new record will be entered automatically.
The empty icon helps us to delete database tables, delete and save empty tables.
The drop icon is used to delete the entire table and its contents.