'peterlaursen' wrote on '13:
… Also check the CREATE VIEW statement again,please – as I cannot create this VIEW (I get 'syntax error')…
hello, it was just part of view only for example..
here is full sql for “demonstration”:
tables:
Code:
CREATE TABLE `g_Tree` (
`treeID` INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (`treeID`)
);
CREATE TABLE `g_TreeAlias` (
`treeID` INT(11) NOT NULL,
`alias` VARCHAR(50) NOT NULL,
PRIMARY KEY (`treeID`,`alias`)
);
view:
Code:
CREATE
VIEW `test`.`g_view_test`
AS
(
SELECT ta.* FROM g_Tree t
INNER JOIN g_TreeAlias ta ON t.treeID=ta.treeID
);
result for “SHOW CREATE VIEW g_view_test”:
Code:
g_view_test CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `g_view_test` AS (
select `ta`.`treeID` AS `treeID`,`ta`.`alias` AS `alias`
from (`g_tree` `t`
join `g_treealias` `ta` on((`t`.`treeID` = `ta`.`treeID`))
)
)
utf8
utf8_general_ci
I will write the same on mysql forum …
Edit: and thank you for your realy quick answer 🙂
