php的sql语句用变量赋值 sql语句变量赋值

insert into `ocenter_menu`(`title`,`pid`,`sort`,`url`,`hide`,`tip`,`group`,`is_dev`,`icon`,`module`) values

('计划任务列表','74','0','admin/schedule/scheduleList','0','','计划任务','0','','');

set @pid=0;

select @pid:= id from `ocenter_menu` where title = '计划任务列表';

insert into `ocenter_menu`(`title`,`pid`,`sort`,`url`,`hide`,`tip`,`group`,`is_dev`,`icon`,`module`) values

('新增/编辑计划任务',@pid,'0','Schedule/editSchedule','1','','计划任务','0','',''),

('运行/停止计划任务',@pid,'0','admin/schedule/run','1','','计划任务','0','',''),

('查看日志',@pid,'0','Schedule/showLog','1','','计划任务','0','',''),

('清空日志',@pid,'0','admin/schedule/clearLog','1','','计划任务','0','',''),

('重启计划任务',@pid,'0','Schedule/reRun','1','','计划任务','0','',''),

('设置计划任务状态',@pid,'0','Schedule/setScheduleStatus','1','','计划任务','0','','');