title: MySQL/MariaDB: Can't create a procedure using the case statement
body: <p>I am struggling with the case statement of MySQL. I want to use it in a procedure but I am getting an error (#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 4) every time I try to create the procedure. I made the procedure as easy as possible to avoid other mistakes which have nothing to do with the case statement. This is what I was trying at the moment:</p>
  
  <pre><code>drop PROCEDURE if EXISTS test;
  create PROCEDURE test()
  BEGIN
  CASE
  when true THEN INSERT INTO testtable VALUES (DEFAULT);
  end case;
  END
  </code></pre>
  
  <p>I really don't know where the mistake is. The manual says the sytax is this:</p>
  
  <pre><code>CASE
      WHEN search_condition THEN statement_list
      [WHEN search_condition THEN statement_list] ...
      [ELSE statement_list] 
  END CASE
  </code></pre>
  
  <p>I think I did exactly the same.
  I hope somebody can help me. I am struggling for several hours now.
  BTW: I am using XAMPP with PHPMyAdmin</p>