[an error occurred while processing this directive]

Mysql From Table

                         

Mysql From Table is used to specify the table from which the records is retrieved.

Understand with Example

The Tutorial illustrate an exanple from 'Mysql From Table'. To grasp this example we create  a table 'Stu' that include fieldname and datatype respectively.

 

 

 

 

Create Table Stu

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

Insert Values into Stu

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');

Query for From

The keyword 'from' is used to specify the table 'Stu' from which records is retrieved.

Select * from Stu;

Result

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

 

                         

[an error occurred while processing this directive]