Home >Database >Mysql Tutorial >数据库-初学mysql过程存储遇到问题

数据库-初学mysql过程存储遇到问题

WBOY
WBOYOriginal
2016-06-06 09:33:211192browse

mysql数据库

CREATE OR REPLACE PROCEDURE menuinsert
BEGIN
DECLARE pkno VARCHAR(50);
SELECT menu_pkno INTO pkno FROM menu_info WHERE name='系统设置';
INSERT INTO menu_info (menu_pkno,name,parent_pkno,stage,sort)
VALUES
(UUID(), '项目设置', pkno, '2','1');
END;
EXECUTE menuinsert();

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn