MySQL, How to pass @var after ADD keyword?
<p>First I create my table with one text column in 5.6.34 - MySQL Community Server (GPL) like so :</p>

<pre><code>CREATE TABLE `$_query_test`.`t1` ( c1 TEXT NOT NULL ) ENGINE = InnoDB;
</code></pre>

<p>Then I execute: </p>

<pre><code>SET @var = 321; INSERT INTO `t1` (c1) VALUES (@var);
</code></pre>

<p>I get one entry with a value of <code>321</code> as expected, but when i execute:</p>

<pre><code>SET @var = '_string_';
ALTER TABLE `t1` ADD @var TEXT;
</code></pre>

<p>I get an error </p>

<blockquote>
  <p>#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 '@var TEXT' at line 1</p>
</blockquote>

<p>What is the proper syntax to do something like this? I have searched far and wide and so far got nothing on this.</p>