Create Table In MySQL Database Tutorial Example

How To Create Table In MySQL Database Tutorial Example

Open your MySQL Query Editor then copy & paste the below code to create a database table "test" in MySQL Database Server

   -- How To Create Table In MySQL Database Tutorial Example


   CREATE TABLE test
   (
     TestID int(11) default NULL,
     TestName varchar(100) default NULL,
     TestAge int(11) default NULL
   );

   -- that's it!! mysql database table "test" has been created with 3 columns

      -- is comment in MySQL
      -- in fact it is comment in MSSQL and Oracle as well
   

How To Create Table In MySQL Database Tutorial Example - Result in MySQL Query Editor

 

Related Tutorial Examples

1. MySQL concat function string SQL Example
2. MySQL concat function Aliase SQL Example
3. MySQL concat function SQL Example
4. MySQL concat operator SQL Example
5. MySQL NULL to empty string Example
6. How to ADD Column In MySQL Existing Table Example
7. MySQL Stored Procedure Function: How to Drop a Stored Procedure Example
8. 20 steps to make CakePHP Blog Project