title: The MySQL "DELIMITER" keyword isn't working
body: <p>Ok so, I've been ripping my hairs ou on this one, why doesn't this work?</p>
  
  <pre><code>DELIMITER |
  
  CREATE PROCEDURE Decrypt_pw()
      READS SQL DATA
  BEGIN
    SELECT 'Hey Select';
  END|
  </code></pre>
  
  <p>It's so basic and I'm pretty sure I'm using the correct syntax, what am I missing?</p>
  
  <p>Error:</p>
  
  <pre><code>21:14:07  [DELIMITER - 0 row(s), 0.000 secs]  [Error Code: 1064, SQL State: 42000]  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER |
  
  CREATE PROCEDURE Decrypt_pw()
      READS SQL DATA
  BEGIN
    SELECT 'He' at line 1
   21:14:07  [END| - 0 row(s), 0.000 secs]  [Error Code: 1064, SQL State: 42000]  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END|' at line 1
  </code></pre>
  
  <p>I'm using DbVisualizer, latest version, could this problem be with the software itself?</p>
  
  <p>Perhaps I should explain myself better, the passwords are encrypted in my database (no need to worry), and this allows me to decrypt them, this is for a personal project I'm working on.</p>
  
  <p>I was trying to develop a script that would allow me to run it and set up the necessary databases, tables, etc for that to work, and I require some SPs which must also be created, I'm trying to create an SP through a mysqli_query, is that even possible?</p>
  
  <p>Basically it's for a "setup script" of a php application.</p>
  
  <p>UPDATE: Seems that <a href="https://stackoverflow.com/questions/4575780/how-to-insert-create-stored-procedures-in-mysql-from-php">this</a> is supposed to work, however I can't use objects due to the guys at HostGator -.- not allowing for objects in PHP.</p>
  
  <p>I Have pretty much given up on mysqli since it's just not going to work I'm trying with shell_exec, I'm creating the procedure but when I check the ddl it's empty, it's creating empty procedures but at least it's doing something...</p>