title: why does `DELIMITER //` gives error in MariaDB?
body: <p>when I run the command </p>
  
  <pre><code>DELIMITER //
  </code></pre>
  
  <p>it returns this error :  </p>
  
  <blockquote>
    <p>#42000You have an error in your SQL syntax; check the manual that
    corresponds to your MariaDB server version for the right syntax to use
    near 'DELIMITER //' at line 1</p>
  </blockquote>
  
  <pre><code>show variables like '%version%'
  </code></pre>
  
  <p>returns </p>
  
  <pre><code>Variable_name           Value   
  -------------           -----   
  innodb_version          5.6.36-82.1 
  protocol_version        10  
  slave_type_conversions      
  version                 10.0.32-MariaDB 
  version_comment         Source distribution 
  version_compile_machine     
  version_compile_os      Linux   
  version_malloc_library  system  
  </code></pre>
  
  <p>What am i doing wrong ? From what version can I use the delimiter command ?</p>
  
  <p><strong>edit:</strong>  </p>
  
  <p>I tried this example from the comments : <a href="https://mariadb.com/kb/en/library/delimiters/" rel="nofollow noreferrer">https://mariadb.com/kb/en/library/delimiters/</a><br>
  and it returns this error :  </p>
  
  <blockquote>
    <p>#42000You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use
    near 'DELIMITER //</p>
    
    <p>CREATE FUNCTION FortyTwo() RETURNS TINYINT DETERMINISTIC</p>
    
    <p>BEGIN ' at line 1.</p>
  </blockquote>
  
  <p><strong>SOLUTION :</strong><br>
  I did the command from <code>DataBase WorkBench v5.3.4b Lite</code> and it failed.<br>
  Now I downloaded <code>MySql WorkBench 6.3</code> and there the command works without any problem.  </p>
  
  <p>So the problem is in <code>DataBase WorkBench v5.3.4b Lite</code>.<br>
  I recommend to not use this tool.</p>
  
  <p>My problem is that it also still fails in my Delphi 7 client, so I guess I need to find better connection components</p>