title: MySQL Declaration PHPMyADMIN
body: <p>Im want to run queries with declaraions in PHPMYADMIN. </p>
  
  <p>Here my querycode</p>
  
  <pre><code>declare @shopdomain varchar(30);
  SET @shopdomain = 'newdomain.com';
  UPDATE trans SET tval=REPLACE(name,'olddomain.de', @shopdomain ) WHERE name LIKE 'olddomain.de';
  UPDATE settings SET tval=REPLACE(name,'olddomain.de', @shopdomain ) WHERE name LIKE 'olddomain.de';
  UPDATE...
  </code></pre>
  
  <p>PHPMYADMIN shows this error</p>
  
  <pre><code>#1064 - 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 'declare @shopdomain varchar(30)' at line 1 
  </code></pre>
  
  <p>What im doing wrong? </p>