Calling simple MySQL sproc with variables

Vote count:

0

I defined my sproc with phpmyadmin, and the variables that I want to use are defined. The sproc saves fine

This is my SQL statement:

CALL AddToTable (@KwhS = 240, @DateS = '12/01/1999', @Days = '20')

Within the sproc I defined that I wanted the column Kwh to be @KwhS but I get the error "Column Kwh cannot be null."

Is there something wrong with my syntax? I thought that defining the variables through phpmyadmin would be enough that I didn't have to declare them, that it did that automatically, maybe I'm wrong on that part?

This is the sproc:

INSERT INTO DummyData (Name,Kwh,DateString,Days) VALUES ('Dummy',@KwhS,@DateS,@Days)

asked 3 mins ago

hoppiness

1

Calling simple MySQL sproc with variables