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 | +------+---------+ |