开发者社区> 问答> 正文

sql语句执行异常问题

sql语句如下:

delete from video_category_new where id in (51063,65692,62537,27114,67282,56530,73931,73930,61186,63489,56592,63968,71849,65529,60409,60282,53108,21559,21180,71396,21841,54720,67271,662,580,69559,726,568,570,2612,2598,397,65408,22852,28663,55508,38880,66169,66176,1393,1392,1391,23234,70583,60890,52928,73668,64771,53072,51771,68987,68986,68984,68961,68963,68990,68993,68995,68996,68998,69000,68962,68985,68988,68965,56557,60826,62577,69466,55452,74060,74061,56519,57472,57262,56431,56308,72378,58590,57893,25932,25373,54168,63835,71681,65265,55976,43297,73845,3778,65372,60457,53420,68676,28710,51053,64985,31824,49794,1503,50523,62332,3246,65844,66017,67190,66452,47442,67199,33451,28350,64309,72970,70803,3280,27798,28007,57086,54504,54505,2624,50573,20564,73752,20562,6648,24757,6819,72985,57749,73765,7295,63347,64445,6930,74405,72673,63480,49838,67767,68086,71642,51501,61473,69637,70491,64754,71969,66840,67028,66838,54392,49839,36910,1361,49989,1549,29661,2280,1551,6987,59138,2467,2186,2184,2465,1328,1329,1330,2274,1217,1219,1189,1214,1197,1224,1222,1216,122);
结果是:
Query OK, 306 rows affected
修改sql语句 改为not in
结果是:
Query OK, 306 rows affected
求解:这是怎么回事,难倒sql 语句有长度限制吗?
补充:表video_category_new中包含所有的in中的id

展开
收起
落地花开啦 2016-02-14 15:58:24 2422 0
1 条回答
写回答
取消 提交回答
  • 喜欢技术,喜欢努力的人

    很明显in和not int是反的, sql 语句的长度限制一般是看你的toad或者plsql之类有关

    2019-07-17 18:42:41
    赞同 展开评论 打赏
问答分类:
SQL
问答标签:
问答地址:
问答排行榜
最热
最新

相关电子书

更多
SQL Server 2017 立即下载
GeoMesa on Spark SQL 立即下载
原生SQL on Hadoop引擎- Apache HAWQ 2.x最新技术解密malili 立即下载