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. Type INT (Integer); 
  3. Size (number of houses your whole number will have); 
  4. PRIMARY index; 
  5. Check the box "A.I." (so that the field is automatically incremented). 

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. 1. Click on a table, it is located on the left side, as the following image: 2. Then you click on "View". Then "Create View". 3. 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. 1. Click on your database which is located on the left side, after that, click on "Routines". 2. Then click on "Create new Routine". 3. Fill in the data 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: ...
    • How to access PhpMyAdmin in your hosting?

      When hosting with Scriptcase, phpMyAdmin is already installed as standard, you just need to access it through cPanel. See how to access cPanel : Aqui phpMyAdmin is a SQL database manager where you can make changes to your database. - Through cpanel ...
    • How to import a database in PhpMyAdmin?

      Step 1 1 - In cPanel, go to “PhPMyAdmin”; Step 2 In the top bar of your PHPmyadmin click on "Import"; Click the "Choose File or File" button and select your database (.sql); Step 3 Then correctly define the settings you want for import as in the ...