SQL Analyzer


Explain Extended

ID Select Type Table Access Type Possible Keys Used Key Key Length Ref Rows Examined Filtered Extra
1 SIMPLE 0 0.00% Impossible WHERE noticed after reading const tables

Original SQL Statement

select 
  dc_type, 
  dc_std_amt, 
  add_emoney_type, 
  add_emoney_std_amt, 
  free_deliveryfee, 
  free_deliveryfee_std_amt 
from 
  gd_member_grp 
where 
  level = ''

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  NULL AS `dc_type`, 
  NULL AS `dc_std_amt`, 
  NULL AS `add_emoney_type`, 
  NULL AS `add_emoney_std_amt`, 
  NULL AS `free_deliveryfee`, 
  NULL AS `free_deliveryfee_std_amt` 
from 
  `pravs`.`gd_member_grp` 
where 
  0