update b set count = (b.count - 1), update_time = now() where b.pl_code = xx and b.s_date = 'xxxx-xx-xx' and b.start_time <= 'xx:xx:xx' and b.end_time > 'xx:xx:xx';
只有唯一主键 那么这条语句怎么优化呀,请求大神不吝赐教, 歇息
...全文
3664打赏收藏
mysql update时快时慢怎么回事
update b set count = (b.count - 1), update_time = now() where b.pl_code = xx and b.s_date = 'xxxx-xx-xx' and b.start_time 'xx:xx:xx'; 只有唯一主键 那么这条语句怎么优化呀,请求大神不吝赐教, 歇息