0

I want to know what's the order of execution order of MySql clauses also the logical order of MySql clauses.

Arbër Emini
  • 1
  • 1
  • Please explain the "logical order of MySQL clauses". – Gordon Linoff Jun 16 '17 at 02:17
  • Maybe show us a query about which you have a doubt. I don't think the "logical" and "execution" orders should be any different. – Tim Biegeleisen Jun 16 '17 at 02:23
  • Are you talking about how expressions are evaluated? Like MDAS in math? (*M*ultiplication and *D*ivision then *A*ddition and *S*ubtraction) Or something else? – Sloan Thrasher Jun 16 '17 at 02:42
  • With Logical Order I mean the order of all clauses when I write a query: (ex): SELECT * FROM table WHERE id=10; here the first is SELECT the second is FROM and so on. The Execution order is the order of clauses that get executed by DBMS(I think the FROM clause is executed first!) So I want to get the order of all clauses, the logical and execution order. Thank you! – Arbër Emini Jun 16 '17 at 03:52

0 Answers0