CODEWITHSUNDEEP
mysql
Null Pointer
Null Pointer

Reputation: 9289

MYSQL query doubt - storing selected value to variables

i am using a stored procedure. i declared 2 varaibles . shown below

DECLARE pProductCode          VARCHAR(15);

 DECLARE pProductVersion       VARCHAR(30);

i am selecting ProductCode and prodcuctVersion using a query from a table . shown below

 SELECT  ProductCode, ProductVersion
        FROM packages
       WHERE PackageID = pPackageID;

my question is how can i store the selected values productcode and productversion to the declared variables pProductCode and pProductVersion respectively.

i tried this

 SELECT pProductCode = ProductCode, pProductVersion = ProductVersion
        FROM packages
       WHERE PackageID = pPackageID;

but its not working

Upvotes: 0

Views: 1350

Answers (1)

Null Pointer
Null Pointer

Reputation: 9289

In MySQL to store a column in a variable we use a SELECT INTO statement. For example: 

SELECT ProductCode, ProductVersion
  INTO pProductCode, pProductVersion
  FROM packages
 WHERE PackageID = pPackageID;

packageID is a parameter.

Upvotes: 2

Related Questions