select * from d_storage_out_info d where d.soi_amount>30
alter table d_storage_out_info add index(soi_amount)
show index from d_storage_out_info
alter table d_storage_out_info drop index soi_amount
//drop index soi_amount on d_storage_out_info
select * from d_storage_out_info d where d.soi_amount>30
alter table d_storage_out_info add index(soi_amount)
show index from d_storage_out_info
alter table d_storage_out_info drop index soi_amount
//drop index soi_amount on d_storage_out_info