How to create a table in PhpMyAdmin?

How to create a table in PhpMyAdmin?

To create a table in phpMyadmin, you must first access phpMyadmin through cPanel. 
 
- Click on the database you want to create the table, which is located on the left side;
- Now click on "Create table", type the name of the table and the number of fields, and click "Run";
- One of your fields should be increased automatically. We normally use this field as 
  the requested line identifier (ID).
  
 In this field you must fill in the following: 
        
  1. Name; 
    2.     
  2. Type INT (Integer); 
    3.    
  3. Size (number of houses your whole number will have); 
    4.     
  4. PRIMARY index; 
    5.     
  5. Check the box "A.I." (so that the field is automatically incremented). 
    6. 
  
The other fields can be text with a character limit (VARCHAR, 255). 
  
In addition, you can place other types of fields, depending on the data that 
will be included in that field.

- After filling in all the data, just click "Save"; 
- It will be displayed in the created table.

    • Related Articles

    • How to create a VIEW in phpMyAdmin?

      To create a View in phpMyadmin, you must first access phpMyadmin through cPanel.  - Click on a table, it is located on the left side, as the following image: - Then you click on "View". - Then "Create View". - You will be presented with a form to ...

    • How to create Procedure in phpMyAdmin?

      To create a Procedure in phpMyadmin, you must first access phpMyadmin through cPanel.  - Click on your database which is located on the left side, after that, click on "Routines". - Then click on "Add Routine". - Fill in the data and parameters and ...

    • How to export your database in phpMyAdmin?

      To export your database on phpMyadmin, you must access phpMyadmin through cPanel.  - You must choose the database you want to export.  - Click on the MySQL database you want to export, it is located on the left side, as shown in the following image: ...

    • Import a CSV file to MYSQL via PHPMYADMIN

      I was given access to an existing instance of MySQL via phpMyAdmin. My task was to import a CSV file using the import feature on phpMyAdmin. First, I went to the the main phpMyAdmin page. Next, I clicked on the database instance that I am interested. ...

    • How to access PhpMyAdmin in your hosting?

      When hosting with Scriptcase the phpMyAdmin is already installed as standard, you just need to access it through cPanel.  Through cpanel you go to "Database", then click on "phpMyAdmin", and you will be directed to the phpMyAdmin page. You will be ...