Computer scienceFundamentalsSQL and DatabasesDBMSMySQLDB objects

Stored Procedure Parameters

Theory

New price

Report a typo

We have a table named products with such fields:

  • id – INT
  • name – VARCHAR(255)
  • price – INT

Create the stored procedure named PriceUpdater that will update the price of the product by its name. It should take two parameters: input_name and input_price with the same datatype in corresponding fields.

Write an SQL statement





___

Create a free account to access the full topic