MYSQL - What is a sequence of execution of select * from tablename?

GeekInterview.com > Interview Questions > Database > MYSQL

Go To First | Previous Question | Next Question

MYSQL | Question 38 of 45

What is a sequence of execution of select * from tablename?

Total Answers and Comments: 4

Last Update: March 10, 2008 Asked by: nitin.pathak05

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

February 14, 2008 05:11:40

sampra

Member Since: February 2008 Contribution: 279

RE: What is a sequence of execution of select * from tablename?

Identifi table and then take data (row) in forwad order

Is this answer useful? Yes | No

February 20, 2008 05:55:42

rockxy1214

Member Since: February 2008 Contribution: 8

RE: What is a sequence of execution of select * from tablename?

select * from tablename
DB will get the column name from Information_scheme
and then get the data out as per the conditions

Is this answer useful? Yes | No

February 20, 2008 06:12:35

sampra

Member Since: February 2008 Contribution: 279

RE: What is a sequence of execution of select * from tablename?

Identifiy table and then take data (row) in forwad order and then print on console accordoing to condition.

Is this answer useful? Yes | No

March 10, 2008 08:04:18

deep_pinu

Member Since: January 2008 Contribution: 9

RE: What is a sequence of execution of select * from tablename?

hey,here it is :-

-select/update/delet/insert
- from
-where
-group by
-having
-order by

I think this is the oder of the execution.

Is this answer useful? Yes | No