mysql 如何把这些语句写一起

wxchello

@Ta 2020-11-04 3372点击

DELETE FROM mac_vod WHERE vod_year = '1991'
DELETE FROM mac_vod WHERE vod_year = '1992'
DELETE FROM mac_vod WHERE vod_year = '1993'
DELETE FROM mac_vod WHERE vod_year = '1994'

上面语句，我要一条一条输入执行，很麻烦。
能不能写成一条语句呀
妇炎洁里放松脚

隐藏样式查看源码

回复列表(3|隐藏机器人聊天)

2

读书顶个鸟用

@Ta / 2020-11-04 / 样 / 源

between
in
or
< and >
小米Mix3
3

MXB_123

@Ta / 2020-11-04 / 样 / 源
```
DELETE FROM mac_vod WHERE vod_year in('1991','1992','1993','1994')
```
天健行，君子以自强不息；地势坤，君子以厚德载物。
4

wxchello

@Ta / 2020-11-05 / 样 / 源

@MXB_123，多谢大佬
Redmi Note8 Pro
妇炎洁里放松脚

添加新回复

回复需要登录。