delimiter //
mysql> CREATE OR REPLACE PROCEDURE .tb_pagepower_Get_List
SELECT
`ID`,
`S_MenuName`,
`S_MenuURL`,
`I_ParentID`,
`I_Level`,
`I_PowerID`,
`I_TYPE`,
`S_PICURL`,
`I_MenuType`,
`I_Sort`,
`I_IsDelete`
FROM
`tb_pagepower`;
SELECT count(*) as TotalRowCount
FROM `tb_pagepower`;
END;
-> //
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROCEDURE .tb_pagepower_Get_List
SELECT
`ID`,
`S_Me' at line 1
mysql>
请问:问题出在何处?谢谢
我第一次用mysql 写代码....
mysql> CREATE OR REPLACE PROCEDURE .tb_pagepower_Get_List
SELECT
`ID`,
`S_MenuName`,
`S_MenuURL`,
`I_ParentID`,
`I_Level`,
`I_PowerID`,
`I_TYPE`,
`S_PICURL`,
`I_MenuType`,
`I_Sort`,
`I_IsDelete`
FROM
`tb_pagepower`;
SELECT count(*) as TotalRowCount
FROM `tb_pagepower`;
END;
-> //
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROCEDURE .tb_pagepower_Get_List
SELECT
`ID`,
`S_Me' at line 1
mysql>
请问:问题出在何处?谢谢
我第一次用mysql 写代码....
-> begin
-> SELECT
-> `ID`,
-> `S_MenuName`,
-> `S_MenuURL`,
-> `I_ParentID`,
-> `I_Level`,
-> `I_PowerID`,
-> `I_TYPE`,
-> `S_PICURL`,
-> `I_MenuType`,
-> `I_Sort`,
-> `I_IsDelete`
-> FROM
-> `tb_pagepower`;
-> SELECT count(*) as TotalRowCount
-> FROM `tb_pagepower`;
-> END
-> /
Query OK, 0 rows affected (0.00 sec)
SELECT
`ID`,
少了个BEGIN