Mysql From

Mysql From specify the table from which records is retrieved.

Understand with Example

The Tutorial illustrate an example from 'Mysql From'. To understand example we create a table 'stu' with required fieldnames and datatypes as per required.

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 value into 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 Query From show you the table from which records are retrieved.

Select * from Stu;

Result

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