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

Related Tags for Mysql From Table:
sql,  mysql,  c,  table,  sed,  tab,  if,  ie,  record,  records,  to,  ci,  e,  use,  trie,  pe,  from,  m,  tr,  spec,  retrieve,  which,  s,  sp,  my,  is,  rds,  s,  s,  ri,  rd,  th,  ab,  abl,  om,  o

More Tutorials from this section

• MySQL Absolute Value
• MySQL Addition
• MySQL Add Column
• MySQL Affected Rows
• MySQL Area
• MySQL Arithmetic
• MySQL ASC
• MySQL Ascending Command
• MySQL Auto_Increment
• MySQL Boolean Value
• Mysql Switch CASE
• Mysql Check
• MySQL Converting Expression
• Mysql Decimal Datatype
• Mysql Describe
• Mysql Else Condition
• Mysql Exists
• Mysql For Loop
• Mysql From
• PHP SQL IF Statement

Ask Questions?    Discuss: Mysql From Table  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):