dstorm

var_dump of output of PMA_SQP_analyze()

Jun 2nd, 2014
241
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.28 KB | None | 0 0
  1. array (size=1)
  2. 0 =>
  3. array (size=18)
  4. 'querytype' => string 'SELECT' (length=6)
  5. 'select_expr_clause' => string 'inst.inst_name as `name` , inst_estb_year eyear ' (length=48)
  6. 'position_of_first_select' => int 0
  7. 'from_clause' => string 'inst_master inst ' (length=17)
  8. 'group_by_clause' => string '' (length=0)
  9. 'order_by_clause' => string '' (length=0)
  10. 'having_clause' => string '' (length=0)
  11. 'limit_clause' => string '' (length=0)
  12. 'where_clause' => string '' (length=0)
  13. 'where_clause_identifiers' =>
  14. array (size=0)
  15. empty
  16. 'unsorted_query' => string 'select inst.inst_name as `name`,inst_estb_year eyear from inst_master inst' (length=74)
  17. 'queryflags' =>
  18. array (size=1)
  19. 'select_from' => int 1
  20. 'select_expr' =>
  21. array (size=2)
  22. 0 =>
  23. array (size=6)
  24. 'expr' => string 'inst.inst_name' (length=14)
  25. 'alias' => string 'name' (length=4)
  26. 'db' => string '' (length=0)
  27. 'table_name' => string 'inst' (length=4)
  28. 'table_true_name' => string 'inst_master' (length=11)
  29. 'column' => string 'inst_name' (length=9)
  30. 1 =>
  31. array (size=6)
  32. 'expr' => string 'inst_estb_year' (length=14)
  33. 'alias' => string 'eyear' (length=5)
  34. 'db' => string '' (length=0)
  35. 'table_name' => string '' (length=0)
  36. 'table_true_name' => string '' (length=0)
  37. 'column' => string 'inst_estb_year' (length=14)
  38. 'table_ref' =>
  39. array (size=1)
  40. 0 =>
  41. array (size=5)
  42. 'expr' => string 'inst_master inst' (length=16)
  43. 'db' => string '' (length=0)
  44. 'table_name' => string 'inst_master' (length=11)
  45. 'table_alias' => string 'inst' (length=4)
  46. 'table_true_name' => string 'inst_master' (length=11)
  47. 'foreign_keys' =>
  48. array (size=0)
  49. empty
  50. 'create_table_fields' =>
  51. array (size=0)
  52. empty
  53. 'section_before_limit' => string 'select inst.inst_name as `name`,inst_estb_year eyear from inst_master inst' (length=74)
  54. 'section_after_limit' => string '' (length=0)
Add Comment
Please, Sign In to add comment