解决方案 »
- ●●● mysql时间范围查询,我的怎么查不出来数据,请高手指点,已经搞了2天了没发现问题
- 求sql语句(mysql)
- 关于MySQL的Datatime字段的存储方式问题(高手请进)
- 300分,高手都来!!,最新1126版 ,MySQL 实现中英文混合排序,离成功只差一步!新手也都来学习一下!!!!!!!
- 求一优化SQL
- 怎样在redhat 9里安装mysql 4.1beta
- 怎样卸载MyODBC???????????
- 帮忙看下这个要求要怎么实现
- 请推荐一款生成数据库个文档的工具啊
- mysql 5.7 sql_mode修改后无效
- 删除表中重复记录.只保留一条记录
- win7 x64 装MySQL
CREATE PROCEDURE `P0001Insert`(p_PNO VARCHAR(10), p_TITLE VARCHAR(100), p_NAME VARCHAR(100))
BEGIN
select count(*) into @num from P0001 where PNO =p_PNO;
if @num>1 then
insert into P0001(PNO, TITLE, NAME)values (p_PNO, p_TITLE, p_NAME);
else
update P0001 set TITLE = p_TITLE, NAME = p_NAME where PNO = p_PNO;
end if;
END$$
delimiter ;
delimiter //
CREATE PROCEDURE `P0001Insert`(p_PNO VARCHAR(10), p_TITLE VARCHAR(100), p_NAME VARCHAR(100))
BEGIN
if (select 1 from P0001 where PNO =p_PNO) is null then
insert into P0001(PNO, TITLE, NAME)values (p_PNO, p_TITLE, p_NAME);
else
update P0001 set TITLE = p_TITLE, NAME = p_NAME where PNO = p_PNO;
end if;
END;
//