Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training

Mysql Create Table

The section of Tutorial will help you to create a table in database. To grasp this example, we create a table 'Stu' with required fieldname and datatype respectively.

Ads

Mysql Create Table

     

Mysql Create Table is used to create a table in database.

Understand with Example

The section of Tutorial will help you to create a table in database. To grasp this example, we create a table 'Stu' with required fieldname and datatype respectively.

 

 

 

Create Table Stu

Create Table Stu(Id int,Name Varchar(15));

Insert values into Stu

The insert into is used to add  the records or rows to the table 'Stu'.

Insert Into Stu values(1,'Ajay');
Insert Into Stu values(2,'Bhanu');
Insert Into Stu values(4,'Rakesh');
Insert Into Stu values(5,'Santosh');
Insert Into Stu values(3,'Komal');

Table Stu

To view the detail or table records we use select Query that return you the records from table 'Stu'.

+------+---------+
| Id   | Name    |
+------+---------+
| 1    | Ajay    |
| 2    | Bhanu   |
| 4    | Rakesh  |
| 5    | Santosh |
| 3    | Komal   |
+------+---------+

Advertisements

Online Training Classes

Share on Google+Share on Google+

Mysql Create Table

Posted on: January 20, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: Mysql Create Table  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads