Select Query

Example Table

Table Name : tbl_student_record

id	name	class	subject	city	phone	fee	fee_date
1	Mohan	2nd	Math	Agra	999999990	500	2018-01-02
2	Pooja	3rd	English	Delhi	999999991	200	2018-01-11
3	Rahul	4th	Math	Agra	999999992	300	2018-01-05
4	Suresh	2nd	English	Agra	999999993	400	2018-01-22
5	Vivek	3rd	Math	Agra	999999994	500	2018-01-01
6	Anuj	2nd	English	Delhi	999999995	600	2018-01-31
7	Sanju	4th	Math	Agra	999999996	400	2018-01-17
8	Rohit	3rd	English	Delhi	999999997	700	2018-01-10
9	Mahesh	3rd	Math	Agra	999999998	800	2018-01-24
10	Munesh	4th	English	Delhi	999999999	200	2018-01-09

if you want all records from table "tbl_student_record". you can get this using below mentioned Query..

select * from tbl_student_record

Output

 

id	name	class	subject	city	phone	fee	fee_date
1	Mohan	2nd	Math	Agra	999999990	500	2018-01-02
2	Pooja	3rd	English	Delhi	999999991	200	2018-01-11
3	Rahul	4th	Math	Agra	999999992	300	2018-01-05
4	Suresh	2nd	English	Agra	999999993	400	2018-01-22
5	Vivek	3rd	Math	Agra	999999994	500	2018-01-01
6	Anuj	2nd	English	Delhi	999999995	600	2018-01-31
7	Sanju	4th	Math	Agra	999999996	400	2018-01-17
8	Rohit	3rd	English	Delhi	999999997	700	2018-01-10
9	Mahesh	3rd	Math	Agra	999999998	800	2018-01-24
10	Munesh	4th	English	Delhi	999999999	200	2018-01-09

if you want specific field records from table "tbl_student_record". you can get this using below mentioned Query..

select id,name,city from tbl_student_record

Output

 

id	name	city
1	Mohan	Agra
2	Pooja	Delhi
3	Rahul	Agra
4	Suresh	Agra
5	Vivek	Agra
6	Anuj	Delhi
7	Sanju	Agra
8	Rohit	Delhi
9	Mahesh	Agra
10	Munesh	Delhi

To Learn More in Hindi watch this Video

Select query in mysql in hindi

If love this tutorial Please Like this page