MySQL stored procedure 3:if statement

--if/else StatementsifConditions ThenSQL statementsElseSQL statements
ElseIf
SQL statementsEnd if;Create procedureTest1 ( Number int)  begin  if  Number >  Ten  Then    Select User(); Else    Select 'Please input a number >'; End if; End$

Mysql> Create procedureTest1 ( -    Number int     - )     -   begin     -   if  Number >  Ten  Then     -     Select User();  -   Else     -     Select 'Please input a number >';  -   End if;  -   End$Query OK,0Rows Affected (0.00sec) MySQL>Call test1 () $ERROR1318(42000): Incorrect Number  ofArguments for PROCEDURETest.test1; Expected1, got0MySQL>Call Test1 ( One)$+----------------+| User()|+----------------+|Root@localhost |+----------------+1Rowinch Set(0.00sec) Query OK,0Rows Affected (0.01sec) MySQL>Call Test1 (1)$+----------------------------+|Please input a Number > Ten |+----------------------------+|Please input a Number > Ten |+----------------------------+1Rowinch Set(0.00sec) Query OK,0Rows Affected (0.01sec) MySQL>

MySQL stored procedure 3:if statement