mysql_query()不能正常解析sql
一个sql语句，直接放到mysql里运行是正常的
但用php的mysql_query运行该sql后结果却不同，会是mysql_query不能解析的原因吗？
sql如下：
INSERT INTO analysis.caomei_of_list_pvuv <br /> (region,isp,uv,pv,date) <br /> SELECT<br /> tb2.region,tb2.isp,tb2.uv,tb2.pv,'2014-05-14' AS date <br /> FROM <br /> (<br /> SELECT <br /> tb.region,tb.isp, COUNT(tb.mac) AS uv,<br /> SUM(tb.mac_num) AS pv <br /> FROM <br /> caomei_20140515.caomei_1 AS tb <br /> WHERE <br /> tb.date = '2014-05-14' <br /> GROUP BY tb.region, tb.isp <br /> ) AS tb2 <br /> LEFT JOIN <br /> (<br /> SELECT <br /> tb6.region,tb6.isp,tb6.uv,tb6.pv <br /> FROM <br /> analysis.caomei_of_list_pvuv AS tb6 <br /> WHERE <br /> tb6.date='2014-05-14' <br /> ) AS tb1 <br /> <br /> ON tb2.region = tb1.region <br /> WHERE <br /> tb1.region IS NULL <br /> AND tb2.region IS NOT NULL <br /><br /> ;
——解决方案——————–
NSERT INTO analysis.caomei_of_list_pvuv
(region,isp,uv,pv,date)
SELECT
本文来源gaodai$ma#com搞$$代**码)网8搞代gaodaima码 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
转载请注明原文链接：mysql_query()不能通常解析sql
