Home >Backend Development >PHP Tutorial >sql 语句不执行
sql 语句不执行
- WBOYOriginal
- 2016-06-23 13:58:501304browse
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'
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 不支持 union 表的删除，只能单表删除。
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：shopex安装出错！Next article：请教大神，php怎么数组去掉重复值？