This procedure unassigns an attribute value from a product by
deleting the necessary record from the product_attribute table.
-- Create catalog_remove_product_attribute_value stored procedure
CREATE PROCEDURE catalog_remove_product_attribute_value(
IN inProductId INT, IN inAttributeValueId INT)
BEGIN
DELETE FROM product_attribute
WHERE product_id = inProductId AND
attribute_value_id = inAttributeValueId;
END$$
CHAPTER 11 ?– CATALOG ADMINISTRATION: PRODUCTS AND ATTRIBUTES 350
14. Execute this code, which creates the catalog_set_image, catalog_set_image_2, and catalog_set_
thumbnail stored procedures into your tshirtshop database. We need these functions to change the
primary, secondary and/or thumbnail image of a product when uploading a new picture.
-- Create catalog_set_image stored procedure
CREATE PROCEDURE catalog_set_image(
IN inProductId INT, IN inImage VARCHAR(150))
BEGIN
UPDATE product SET image = inImage WHERE product_id = inProductId;
END$$
-- Create catalog_set_image_2 stored procedure
CREATE PROCEDURE catalog_set_image_2(
IN inProductId INT, IN inImage VARCHAR(150))
BEGIN
UPDATE product SET image_2 = inImage WHERE product_id = inProductId;
END$$
-- Create catalog_set_thumbnail stored procedure
CREATE PROCEDURE catalog_set_thumbnail(
IN inProductId INT, IN inThumbnail VARCHAR(150))
BEGIN
UPDATE product
SET thumbnail = inThumbnail
WHERE product_id = inProductId;
END$$
15.
Pages:
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461