m |
m |
||
Line 1: | Line 1: | ||
− | < | + | <seo title="How to create a database table" metakeywords="database table,create database table,new table,create sqltable" metadescription="How to create a database table" /> |
− | First, log into your '''cPanel => [[Databases]] => phpMyAdmin'''. From the left-side list choose the database you wish to add a table for. | + | <div align=justify>All [http://myidealhost.com/hosting.shtml web hosting plans] provided by [http://myidealhost.com/ MyIdealHost] provides cPanel and it includes the database management application called phpMyAdmin. You can create tables, modify content of the databases, remove it, 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 sql table for. | ||
{{#icon: phpMyAdmin.png|phpMyAdmin}} | {{#icon: phpMyAdmin.png|phpMyAdmin}} | ||
− | To create the database table, enter the desired table name and the number of fields at the bottom of the page. Click '''Go''' to create the table. | + | To create the database table, enter the desired table name and the number of fields at the bottom of the page. Click '''Go''' to create the new table. |
{{#icon: new table.png|create a database table}} | {{#icon: new table.png|create a database table}} | ||
Line 31: | Line 33: | ||
You can choose the following 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''' | * '''Null''' | ||
Line 63: | Line 62: | ||
− | Now you know how to create a database table and | + | Now you know how to create a database table and can add new sql tables to any MySQL database under your account.</div> |