Sign in
apache
/
cayenne
/
8a07e760d6d51377e320970495d1cd1ea1ac3ad5
/
.
/
STABLE-3.0
/
framework
/
cayenne-jdk1.5-unpublished
/
src
/
test
/
resources
/
ddl
/
mysql
/
create-update-sp.sql
blob: aece18d976d1d5f15479166b4eedcd2c9044f294 [
file
] [
log
] [
blame
]
CREATE
PROCEDURE
cayenne_tst_upd_proc
(
IN
p1 DECIMAL
)
BEGIN
UPDATE
PAINTING
SET
ESTIMATED_PRICE
=
ESTIMATED_PRICE
*
2
WHERE
ESTIMATED_PRICE
<
p1
;
END