当前位置:Gxlcms > PHP教程 > sql话语不执行

sql话语不执行

时间:2021-07-01 10:21:17 帮助过:38人阅读

sql 语句不执行
delete from (select * from sys_barcode_1d_y union all select * from sys_barcode_1d_y_bak union all select * from FG_hi_cust_In where hi_no like 'ESC%')a where packageno='xxx'
------解决方案--------------------
delete from (select * from sys_barcode_1d_y union all select * from sys_barcode_1d_y_bak union all select * from FG_hi_cust_In where hi_no like 'ESC%') a where a.packageno='xxx'?
------解决方案--------------------
delete from (select * from sys_barcode_1d_y union all select * from sys_barcode_1d_y_bak 
union all select * from FG_hi_cust_In where hi_no like 'ESC%')a where a.packageno='xxx'

人气教程排行