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 | +------+---------+ |
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Ask Questions? Discuss: Mysql Create Table
Post your Comment