mysql_query()不能正常解析sql

一个sql语句，直接放到mysql里运行是正常的
但用php的mysql_query运行该sql后结果却不同，会是mysql_query不能解析的原因吗？




sql如下：

		INSERT INTO analysis.caomei_of_list_pvuv  									(region,isp,uv,pv,date)  									SELECT										tb2.region,tb2.isp,tb2.uv,tb2.pv,'2014-05-14' AS date   									FROM   									(										SELECT 											tb.region,tb.isp, COUNT(tb.mac) AS uv,											SUM(tb.mac_num) AS pv  										FROM 											caomei_20140515.caomei_1 AS tb 										WHERE 											tb.date = '2014-05-14'  										GROUP BY tb.region, tb.isp 									) AS tb2  									LEFT JOIN 									(										SELECT 											tb6.region,tb6.isp,tb6.uv,tb6.pv 										FROM 											analysis.caomei_of_list_pvuv AS tb6 										WHERE 											tb6.date='2014-05-14'   									) AS tb1 																				ON tb2.region = tb1.region 									WHERE 										tb1.region IS NULL  										AND tb2.region IS NOT NULL 									;

Kimi智能助手

超强AI写作助手，一键总结20w字长文，支持批量文档上传，多端同步内容不怕丢失。论文综述、文档速读、脚本小说创作，统统交给Kimi！实时联网搜索，给你最智能清晰的解答。

1671

查看详情

回复讨论(解决方案)

NSERT INTO  analysis.caomei_of_list_pvuv  
                            (region,isp,uv,pv,date)  
                            SELECT
                                tb2.region,tb2.isp,tb2.uv,tb2.pv,'2014-05-14' AS date   
                            FROM   
                            (
                                SELECT 
                                    tb.region,tb.isp, COUNT(tb.mac) AS uv,
                                    SUM(tb.mac_num) AS pv  
                                FROM 
                                    caomei_20140515.caomei_1 AS tb 
                                WHERE 
                                    tb.date = '2014-05-14'  
                                GROUP BY tb.region, tb.isp 
                            ) AS tb2  
                            LEFT JOIN 
                            (
                                SELECT 
                                    tb6.region,tb6.isp,tb6.uv,tb6.pv 
                                FROM 
                                     analysis.caomei_of_list_pvuv AS tb6 
                                WHERE 
                                    tb6.date='2014-05-14'   
                            ) AS tb1    
                                 
                            ON tb2.region = tb1.region 
                            WHERE 
                                tb1.region IS NULL  
                                AND tb2.region IS NOT NULL 
 
这是不允许的

NSERT INTO  analysis.caomei_of_list_pvuv  
                            (region,isp,uv,pv,date)  
                            SELECT
                                tb2.region,tb2.isp,tb2.uv,tb2.pv,'2014-05-14' AS date   
                            FROM   
                            (
                                SELECT 
                                    tb.region,tb.isp, COUNT(tb.mac) AS uv,
                                    SUM(tb.mac_num) AS pv  
                                FROM 
                                    caomei_20140515.caomei_1 AS tb 
                                WHERE 
                                    tb.date = '2014-05-14'  
                                GROUP BY tb.region, tb.isp 
                            ) AS tb2  
                            LEFT JOIN 
                            (
                                SELECT 
                                    tb6.region,tb6.isp,tb6.uv,tb6.pv 
                                FROM 
                                     analysis.caomei_of_list_pvuv AS tb6 
                                WHERE 
                                    tb6.date='2014-05-14'   
                            ) AS tb1    
                                 
                            ON tb2.region = tb1.region 
                            WHERE 
                                tb1.region IS NULL  
                                AND tb2.region IS NOT NULL 
 
这是不允许的

问题不在于是否有语法错
而在于控制逻辑是循环悖论

但我觉得这样应该没有逻辑问题啊，先查出结果。然后将结果写入自己。
最主要是  php运行的结果和mysql运行的结果不同！！ 

是要尽量避免这种逻辑吗，否则就会出现这种意想不到的结果啊

INSERT INTO a (version)SELECT version FROM a WHERE id=1;

假定第一次执行插入了 1 条
那么第二次执行就会插入 2 条
第三次执行就会插入 4 条

我知道了。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。