dstorm

create table var_dump of output of PMA_SQP_analyze()

Jun 2nd, 2014
244
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.19 KB | None | 0 0
  1. array (size=1)
  2. 0 =>
  3. array (size=16)
  4. 'querytype' => string 'CREATE' (length=6)
  5. 'select_expr_clause' => string '' (length=0)
  6. 'position_of_first_select' => string '' (length=0)
  7. 'from_clause' => string '' (length=0)
  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 'CREATE TABLE IF NOT EXISTS inst_master (
  17. inst_id tinyint(3) unsigned NOT NULL COMMENT 'Primary Key',
  18. inst_name varchar(255) COLLATE latin1_general_ci NOT NULL COMMENT 'Institute Name',
  19. inst_code varchar(10) COLLATE latin1_general_ci NOT NULL COMMENT 'Institute Code as per GTU',
  20. inst_estb_year smallint(4) DEFAULT NULL COMMENT 'Institute Established Year'
  21. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='List of Institutes' AUTO_INCREMENT=5' (length=473)
  22. 'queryflags' =>
  23. array (size=1)
  24. 'reload' => int 1
  25. 'select_expr' =>
  26. array (size=0)
  27. empty
  28. 'table_ref' =>
  29. array (size=0)
  30. empty
  31. 'foreign_keys' =>
  32. array (size=0)
  33. empty
  34. 'create_table_fields' =>
  35. array (size=5)
  36. 'inst_id' =>
  37. array (size=2)
  38. 'timestamp_not_null' => boolean false
  39. 'type' => string 'TINYINT' (length=7)
  40. 'inst_name' =>
  41. array (size=2)
  42. 'timestamp_not_null' => boolean false
  43. 'type' => string 'VARCHAR' (length=7)
  44. 'latin1_general_ci' =>
  45. array (size=1)
  46. 'timestamp_not_null' => boolean false
  47. 'inst_code' =>
  48. array (size=2)
  49. 'timestamp_not_null' => boolean false
  50. 'type' => string 'VARCHAR' (length=7)
  51. 'inst_estb_year' =>
  52. array (size=3)
  53. 'timestamp_not_null' => boolean false
  54. 'type' => string 'SMALLINT' (length=8)
  55. 'default_value' => string 'NULL' (length=4)
Add Comment
Please, Sign In to add comment