Visual FoxPro操作dbf时语句过长换行问题

么么哒思密达

于 2022-07-02 15:39:27 发布

阅读量508

点赞数 1

文章标签：数据库大数据 mysql

本文链接：https://blog.csdn.net/weixin_46410916/article/details/125573726

版权

想必大家应该遇到过，今天我也遇到了，需要用union all连接好几个表，导致语句过长自动换行，解决方法是在每一行后边加英文分号，最后一行不加
如下：

SELECT kmdm,1 as qyh,bmh,'0' as kbbz FROM a.dbf WHERE qkbz='0' AND kbbz like   '%|1-0|%' union all ;
SELECT kmdm,2 as qyh,bmh,'0' as kbbz FROM a.dbf WHERE qkbz='0' AND kbbz like   '%|2-0|%' union all ;
SELECT kmdm,3 as qyh,bmh,'0' as kbbz FROM a.dbf WHERE qkbz='0' AND kbbz like   '%|3-0|%' union all ;
SELECT kmdm,4 as qyh,bmh,'0' as kbbz FROM a.dbf WHERE qkbz='0' AND kbbz like   '%|4-0|%' union all ;
SELECT kmdm,5 as qyh,bmh,'0' as kbbz FROM a.dbf WHERE qkbz='0' AND kbbz like   '%|5-0|%' union all ;
SELECT kmdm,6 as qyh,bmh,'0' as kbbz FROM a.dbf WHERE qkbz='0' AND kbbz like   '%|6-0|%' union all ;
SELECT kmdm,7 as qyh,bmh,'0' as kbbz FROM a.dbf WHERE qkbz='0' AND kbbz like   '%|7-0|%' union all ;
SELECT kmdm,8 as qyh,bmh,'0' as kbbz FROM a.dbf WHERE qkbz='0' AND kbbz like   '%|8-0|%' union all ;
SELECT kmdm,9 as qyh,bmh,'0' as kbbz FROM a.dbf WHERE qkbz='0' AND kbbz like   '%|9-0|%' union all ;
SELECT kmdm,10 as qyh,bmh,'0' as kbbz FROM a.dbf WHERE qkbz='0' AND kbbz like '%|10-0|%'