????3?? ?????select??????м??
??????????????????????????Щ????update??delete????м??????mysql5.6??汾???????????????????????????????explain?????в?????????????д?????в???м????
?????????????????????????????????????????￡?
????Count: 13 Time=73.44s (954s) Lock=0.00s (0s) Rows=0.0 (0)?? ipos[ipos]@2hosts
????update ipos_zdjhd m??ipos_zdjhdtj tj set m.qr=N??m.qrrq='S'??m.qrr='S'??tj.qr=N??tj.qrrq='S'
????where m.ydjh='S' and tj.djbh='S'
?????????д???￡?
????Explain Select m.qr ?? m.qrr ?? tj.qr ?? tj.qrrq from ipos_zdjhd m??ipos_zdjhdtj tj where m.ydjh='17233' and tj.djbh='48632';
??????????????ipos_zdjhd????????????裬??ipos_zdjhd????1076971?е??????????????update??????????????????????????????????????????ipos_zdjhd?????????????????????????????????500????
????С????м???????????????????mysql??????????????????????????????????????????????????????80%?????????????SQL?????