View source

<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'''. Then choose the database you wish to add a table for.

To create the database table, enter the desired table name and the number of fields. Click '''Go''' to create the table.

On the screen that opens you'll be asked to enter the fields' names and the corresponding properties. The properties are as follows:

* '''Type'''

This field allows you to pick the type of the data stored in the corresponding field. See more about the possible choices [http://dev.mysql.com/doc/refman/5.0/en/data-types.html here].

* '''Length/Values'''

The length of the database table field should be entered here.  In case the field type is "enum" or "set", enter the values using the following format: 'a','b','c', etc.

* '''Collation'''

Pick the data collation for each database field.

* '''Attributes'''

You can choose the following attributes:

 '''''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;

* '''Null'''

This allows you to define whether the field value can be NULL. More information about the NULL value can be found [http://dev.mysql.com/doc/refman/5.0/en/problems-with-null.html here].

* '''Default'''

Here you can set the default value for the field.

* '''Extra'''

In the Extra property you can set the field value to auto-increment.

The radio buttons specify an Index for the particular field and the Index type.

* '''Comments'''

This field allows you to add comments, which will be included in the database sql code.

Here you can add Table comments and choose the MySQL Storage Engine and the Collation. Once everything is set, click '''Save'''.


Now you know how to create a database table and use the above steps to manage your MySQL databases.</div>
Return to How to create a database table.
Retrieved from "http://myidealhost.com/tutorials/How_to_create_a_database_table"
Navigation

Search
