000
Knowledgebase
- Portal Home
- Knowledgebase
- phpMyAdmin Series (12)
- Creating a table in a database with phpMyAdmin
Categories
20
Blesta Admin Tutorials
15 Creating Private Nameservers Tutorials
26 Direct Admin End User Tutorials
8 Dream Mail Tutorials
14 Drupal Tutorials
11 Facebook Tutorials
10 FileZilla Tutorials
24 FTP Tutorials
11 Horde Email Tutorials (Oct 2017)
8 IncrediMail Series (8) - SPANISH
8 IncrediMail Tutorials
8 iPad Email Series (8) - SPANISH
8 iPad Email Tutorials
8 iPhone Email Series (8) - SPANISH
8 iPhone Email Tutorials
8 Opera Mail Tutorials
8 Pegasus Mail Tutorials
12 phpMyAdmin Series (12)
26 Plesk Onyx 2017 End User Tutorials
12 PuTTY Series (12)
9 RoundCube Email Tutorials (Oct 2017)
16 SmarterMail Tutorials
10 SquirrelMail Series (10) - SPANISH
8 Thunderbird Email Tutorials
17 Updating DNS Tutorials
10 Windows 10 Mail Series (10)
12 WordPress Basic Series (12) - BRAZILIAN PORTUGUESE
12 WordPress Basic Series (12) - DUTCH
12 WordPress Tutorials
Categories
Creating a table in a database with phpMyAdmin
This video assumes you've already logged in to phpMyAdmin.
Now let's learn how to create a table within a database.
First, select the database in which you want to create a table.
Enter a name for the table.
Enter the number of fields this table is to have, then click Go.
Next, enter the details for each field including a name and field type.
Let's make this first field the Primary Key, and we'll click here to make it Auto_Increment.
The remaining fields will be character fields. Be sure the length is set long enough to accomodate the field values.
When finished, click Save.
That's it! Our new table has been created within our database.
This is the end of the tutorial. You now know how to create database tables with phpMyAdmin.
This video assumes you've already logged in to phpMyAdmin.
Now let's learn how to create a table within a database.
First, select the database in which you want to create a table.
Enter a name for the table.
Enter the number of fields this table is to have, then click Go.
Next, enter the details for each field including a name and field type.
Let's make this first field the Primary Key, and we'll click here to make it Auto_Increment.
The remaining fields will be character fields. Be sure the length is set long enough to accomodate the field values.
When finished, click Save.
That's it! Our new table has been created within our database.
This is the end of the tutorial. You now know how to create database tables with phpMyAdmin.
- 0 Users Found This Useful
Related Articles
Renaming database tables with phpMyAdmin
Renaming database tables with phpMyAdmin This video assumes you've already logged in to...
Deleting a table from a database with phpMyAdmin
Deleting a table from a database with phpMyAdmin This video assumes you've already logged in to...
Exporting databases and tables with phpMyAdmin
Exporting databases and tables with phpMyAdmin This video assumes you've already logged in to...
Importing databases and tables with phpMyAdmin
Importing databases and tables with phpMyAdmin This video assumes you've already logged in to...
Running SQL queries on a database with phpMyAdmin
Running SQL queries on a database with phpMyAdmin This video assumes you've already logged in to...
Powered by WHMCompleteSolution
Loading...
Loading...