The MySQL FROM Clause is used to select some records from a table. It is very important clause in MySQL because it tell from which table you want to retrieve the records. Is is also useful when retrieving records from multiple tables using JOIN condition.
To retrieve records from existing table, use the following syntax:
tablename: The table name from which you want to remove all records.
In the above example, we have fetched records from "tblCustomerLoan"
You can use MySQL Command Line Client to fetched records using FROM clause from "tblCustomerLoan" table. It will look like this:
You can use MySQL Command Line Client to data from multiple tables using INNER JOIN from tables. It will look like this: