title: MySQL throwing error "Statement is incomplete expecting if" when trying to create procedure
body: <p>I have been trying to create a procedure in MySQL but it throws this error whenever I try to run it even though I have specified a delimiter.I'm new to MySQL so I don't know what I'm doing wrong . None of the other questions seem to have my problem</p>
  
  <pre><code>delimiter //
  
  create procedure get_count(in com varchar(20))
  begin  
  
    if(com='gre') then
      select count(*) as "No of Employees" from jobs where min_salary &gt; 10000;
    else if(com='eq') then
      select count(*) as "No of Employees" from jobs where min_salary = 10000;
    else if(com='less') then
      select count(*) as "No of Employees" from jobs where min_salary &lt; 10000;
    else
      select ("Invalid");
    end if; 
  end //
  delimiter ;
  </code></pre>