Update Prefix sales order id in magento

Update Prefix sales order id :




UPDATE ex_eav_entity_store
       INNER JOIN ex_eav_entity_type
         ON ex_eav_entity_type.entity_type_id = ex_eav_entity_store.entity_type_id
SET    ex_eav_entity_store.increment_last_id = 'EL0100001663',ex_eav_entity_store.increment_prefix = 'EL0'
WHERE  ex_eav_entity_type.entity_type_code = 'order'
       AND ex_eav_entity_store.store_id = 1;



UPDATE ex_eav_entity_store
       INNER JOIN ex_eav_entity_type
         ON ex_eav_entity_type.entity_type_id = ex_eav_entity_store.entity_type_id
SET    ex_eav_entity_store.increment_last_id = 'EL0100001647',ex_eav_entity_store.increment_prefix = 'EL0'
WHERE  ex_eav_entity_type.entity_type_code = 'quote'
       AND ex_eav_entity_store.store_id = 1;



UPDATE ex_eav_entity_store
       INNER JOIN ex_eav_entity_type
         ON ex_eav_entity_type.entity_type_id = ex_eav_entity_store.entity_type_id
SET    ex_eav_entity_store.increment_last_id = '100000002'
WHERE  ex_eav_entity_type.entity_type_code = 'invoice'
       AND ex_eav_entity_store.store_id = 1;



UPDATE ex_eav_entity_store
       INNER JOIN ex_eav_entity_type
         ON ex_eav_entity_type.entity_type_id = ex_eav_entity_store.entity_type_id
SET    ex_eav_entity_store.increment_last_id = '100000009'
WHERE  ex_eav_entity_type.entity_type_code = 'shipment'
       AND ex_eav_entity_store.store_id = 1;


UPDATE ex_eav_entity_store
       INNER JOIN ex_eav_entity_type
         ON ex_eav_entity_type.entity_type_id = ex_eav_entity_store.entity_type_id
SET    ex_eav_entity_store.increment_last_id = '100064999'
WHERE  ex_eav_entity_type.entity_type_code = 'creditmemo',ex_eav_entity_store.increment_prefix = 'EL0'
       AND ex_eav_entity_store.store_id = 1;