capitan_nemesis
یک شنبه 01 آذر 1394, 12:13 عصر
با سلام
من یه proc نوشتم با کد update مشکل دارم
DELIMITER $$
create procedure bank_save(id int , bank_mony int, bank_name varchar(50))
begin
if(exists(select * from bank where bank.bank_id = id))
update bank
set bank_mony = bank_mony,
bank_name = bank_name
else
insert bank
select bank_mony , bank_name
end if
end $$
DELIMITER ;
من یه proc نوشتم با کد update مشکل دارم
DELIMITER $$
create procedure bank_save(id int , bank_mony int, bank_name varchar(50))
begin
if(exists(select * from bank where bank.bank_id = id))
update bank
set bank_mony = bank_mony,
bank_name = bank_name
else
insert bank
select bank_mony , bank_name
end if
end $$
DELIMITER ;