<seo title="How to create a database table" metakeywords="database table,create database table,new table" metadescription="How to create a database table" />

<div align=justify>cPanel allows you to manage your databases using phpMyAdmin tool. You can create a database, modify or remove it; create a database table; repair and optimize MySQL tables, etc. In this tutorial we'll let you know how to create a database table using phpMyAdmin.  

First, log into your '''cPanel => [[Databases]] => phpMyAdmin'''. From the left-side list choose the database you wish to add a new table for.

'''''BINARY''''' - the field collation will be binary, e.g. ''utf8_bin'';

'''''UNSIGNED''''' -  the database table field will have positive or 0 numeric  

values;

'''''UNSIGNED ZEROFILL''''' - the field will have positive or 0 numeric values  

and leading zeros will be added to a number;

'''''ON UPDATE CURRENT_TIMESTAMP''''' - the current timestamp is the default  

value for the data type field, and is automatically updated;

Now you know how to create a database table and can add new tables to any MySQL database under your account.</div>