让我再举一个例子…我不能在php中创建这个视图(而我可以在phpmyadmin)
$sql="CREATE VIEW ratings.rtgemissfitch AS
SELECT derivedtable. ISIN
FROM
(SELECT ISIN, MAX(Date_Notation_Emission) FROM ratings.ratingsemissionfitch as derivedtable GROUP BY ISIN) ";
但是我可以在php中这样做:
$sql="CREATE VIEW ratings.rtgemissfitch AS
(SELECT ISIN, MAX(Date_Notation_Emission) FROM ratings.ratingsemissionfitch as derivedtable GROUP BY ISIN) ";
我真的不明白,首先,对不起我的英语,我是法国人…我真的不明白为什么在phpadmin上运行的请求在我的php代码中不起作用…可能是派生表…所以,我希望得到惠誉的最后评级:phpmyadmin中的SQL请求工作完美:
SELECT `DBFITCH`.`ISIN`, `RATING_FITCH`as FITCH_RTG
FROM
(SELECT `ISIN`, MAX(`RATING_DATE`) as LastUpdate
FROM `ratings`.`ratingsemissionfitch` GROUP BY ISIN) as LAST
INNER JOIN `ratings`.`ratingsemissionfitch` as DBFITCH
ON
DBFITCH.`ISIN`= LAST.`ISIN`
AND DBFITCH.`RATING_DATE`=LAST.LastUpdate
在php中,以下代码不能运行:
$sql="CREATE VIEW ratings.rtgemissfitch AS
SELECT DBFITCH.ISIN, RATING_FITCH as FITCH_RTG
FROM
(SELECT ISIN, MAX(RATING_DATE) as LastUpdate
FROM ratings.ratingsemissionfitch GROUP BY ISIN) as LAST
INNER JOIN ratings.ratingsemissionfitch as DBFITCH
ON
DBFITCH.ISIN= LAST.ISIN
AND DBFITCH.RATING_DATE=LAST.LastUpdate";
$req = $bdd->exec($sql);
让我再举一个例子…
我不能在php中创建这个视图(而我可以在phpmyadmin)
$sql="CREATE VIEW ratings.rtgemissfitch AS
SELECT derivedtable. ISIN
FROM
(SELECT ISIN, MAX(Date_Notation_Emission) FROM ratings.ratingsemissionfitch as derivedtable GROUP BY ISIN) ";
但是我可以在php中这样做:
$sql="CREATE VIEW ratings.rtgemissfitch AS
(SELECT ISIN, MAX(Date_Notation_Emission) FROM ratings.ratingsemissionfitch as derivedtable GROUP BY ISIN) ";
我真的不明白…提前感谢,
您的数据库用户可能没有权限运行
CREATE VIEW
?