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 
  grpnm, 
  dc_type, 
  dc_std_amt, 
  dc, 
  add_emoney_type, 
  add_emoney_std_amt, 
  add_emoney, 
  free_deliveryfee, 
  free_deliveryfee_std_amt 
FROM 
  gd_member_grp 
WHERE 
  sno = 0

Converted SQL Statement (MySQL Optimizer)

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