HQL: Difference between revisions

Latest revision as of 20:42, 20 November 2014

SELECT * FROM TableMenu;

FROM tablemenu;

SELECT m.MenuName, o.OptionName 
FROM 
`devmenutest`.menu as m 
LEFT OUTER JOIN 
`devmenutest`.menuoption as o 
ON 
m.id=o.MenuId

SELECT m.menuName , o.optionName
FROM
Menu as m
LEFT OUTER JOIN
m.menuoptions as o

@@ Line 1: / Line 1: @@
+== Basic ==
-SELECT m.menuName, o.optionName
+=== Select ===
+* Mysql syntax
+<syntaxhighlight lang="mysql">
+SELECT * FROM TableMenu;
+</syntaxhighlight>
+* HQL Syntax
+<syntaxhighlight lang="mysql">
+FROM tablemenu;
+</syntaxhighlight>
+== Join ==
+<syntaxhighlight lang="mysql">
+SELECT m.MenuName, o.OptionName
 FROM
-Menuoption as o
+`devmenutest`.menu as m
-INNER JOIN
+LEFT OUTER JOIN
-o.menu as m
+`devmenutest`.menuoption as o
+ON
+m.id=o.MenuId
+</syntaxhighlight>
+* HQL Syntax
+<syntaxhighlight lang="mysql">
+SELECT m.menuName , o.optionName
+FROM
+Menu as m
+LEFT OUTER JOIN
+m.menuoptions as o
+</syntaxhighlight>