---
title: How to Create a Database Table With phpMyAdmin
description: "🌐This guide is also available in Arabic[← اقرأ بالعربية](https://kb.tarweig.com/docs/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%a5%d9%86%d8%b4%d8%a7%d8%a1-%d8%ac%d8%af%d9%88%d9%84-%d9%82%d8%a7%d8%b9%d8%af%d8%a9-%d8%a8%d9%8a%d8%a7%d9%86%d8%a7%d8%aa-%d8%ac%d8%af%d9%8a%d8%af-%d8%a8%d8%a7%d8%b3/) In this tutorial, we’ll show you how to create a database table with phpMyAdmin. We’ll assume that you are already logged into phpMyAdmin. If you are not logged in just follow…"
url: "https://kb.tarweig.com/en/docs/creating-database-tables-phpmyadmin/"
updated: "2026-10-11"
category: Hosting Management
---

# How to Create a Database Table With phpMyAdmin

🌐This guide is also available in Arabic[← اقرأ بالعربية](https://kb.tarweig.com/docs/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%a5%d9%86%d8%b4%d8%a7%d8%a1-%d8%ac%d8%af%d9%88%d9%84-%d9%82%d8%a7%d8%b9%d8%af%d8%a9-%d8%a8%d9%8a%d8%a7%d9%86%d8%a7%d8%aa-%d8%ac%d8%af%d9%8a%d8%af-%d8%a8%d8%a7%d8%b3/)

In this tutorial, we’ll show you how to create a database table with phpMyAdmin. We’ll assume that you are already logged into phpMyAdmin. If you are not logged in just follow the [steps in this tutorial](https://kb.tarweig.com/en/docs/how-to-use-phpmyadmin/) to login.

**1)** First, we’ll need to select the database, in this example, we’ll use the **chemiclo_demo** database.

**2)** You’ll notice that we have a couple of test tables already created, to create a new database table just enter the name of the table in the “**Name**” field and the number of fields you want for this table and click “**Go”**.

**3)** We’ve created the table “demo” and added two columns (name and phone), now we need to set the details of each field within this new table and select **Type** of data the column will hold.  Some of the most  common types are:

**INT =**INTEGER – used to store a number that can be written without a fractional component. (e.g. 2, 10, -44). An integer can be zero, positive, and negative.
 **CHAR** = Characters – used to store character string value of fixed length, the maximum number is of characters is 255.
 **VARCHAR** = Variable Length Characters – used to store variable length alphanumeric data and can store up to 65,535 characters.
 **TEXT** = used for holding large amounts of text.
 **DATE** = Will only hold dates.
 **DATETIME** = Will hold both a date and a time.

 

![](https://kb.tarweig.com/wp-content/uploads/kb-media/misc/phpmyadmin_create_database_table1.png)

 

4) We can also define the **Length/Values** if necessary, the CHAR type will require you to specify the maximum number of characters allowed. All the other fields are optional, however, if you need more detailed information about all the options available you can check the [MySQL Reference Manual](https://dev.mysql.com/doc/refman/5.7/en/create-table.html).

 

**5)** When finished, click “**Save”.**  A message will appear indicating that your table has been created.