PHPMyAdmin is a spectacular open source tool that will allow us to use and manage the databases of your website, where you can insert, edit and delete database records.
The databases are those where all the data that your website needs is stored, such as comments, articles, messages, images and others.
PHPMyAdmin features
- Support for MySQL features.
- Maintenance of database, tables and server for their configuration.
- Delete, copy, create, rename and modify fields, databases and indexes.
- Execute, mark and edit SQL statements and even batch requests.
- Manage processes that have already been stored and explore and delete databases, views, indexes, fields and tables.
- Efficient and intuitive web interface.
- Export data in various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 and open spreadsheet, text, Word, LATEX documents, among others.
- Import data from CSV and SQL files.
- Performing global searches on a database or a subset of it.
- Creation of complex requests using QUERY-by-example (QBE).
- Transformation of data stored in any format using a default function configuration such as displaying BLOB-data in image or download link.
How to create database in PHPMyAdmin?
- First we must log in to PHPMyAdmin, select a database where we will enter to generate modifications.
- Creating a database is very easy, the server configuration of your page could be one of these directories:
// localhost: 8888/phpMyAdmin/
// localhost/phpmyadmin
// your_ip_address/phpmyadmin/ - There we must choose the “Database” tab, we must give a name to the database in the “Create database” field and click on the “Create” button.
- We must confirm that the database was correctly created by searching for it in the “Databases” tab .
How to create tables in PHPMyAdmin?
- To create a table in a database we must select the corresponding database.
There we will find a box where it will allow us to create a new table and we must place a name along with the number of fields within the table and we will click on the “Go” button . - Within the new table we can include the details within each field.
- The first field must be “Primary key”, that is, it will be completed automatically (auto_increment) when adding new entries to the table, this first field must be called “ID” and will be composed of an integer number (Integer) 4 characters long .
- In the rest of the fields to complete will be CHAR (Character) fields, we must make sure that the length (length) is sufficient to order the fields.
- As an example; the second field will be named NAME, its type will be CHAR and the length will be 100 .
- When finished we must click on the “Save” button and our table will be officially created.
Glossary of fields within the table
- Name: Name of the column.
- Type: Type of data that will be stored in the corresponding column.
- Values/length: Length of the field.
- Default: Specify if the column fields obtain a default value.
- Collation: Collation of data for each field.
- Attributes: Any special attributes in the fields.
- Null: Value of the field that can be null.
- Index: Sets an index of the row.
- A_i: Abbreviation for auto increment, if enabled, the values of the fields in the column will increment automatically.
- Comments: You can add a comment that will be included in the SQL code within the database.
This time you have learned how to create databases and tables in PHPMyAdmin in a few steps in order to manage the databases of your web pages, if you want to view the database in another format you must convert the CSV file to Excel and you can edit it No problem. Remember that if you want to learn more about PHPMyAdmin you can stay at Miracomosehace.com and find the most complete information about this tool.