<div>
Just add it anyway. If the field exists, it will return an error. If it doesn't exist, it will add it. If this is part of some longer script, run it with mysql --force &lt;&nbsp;file.sql
</div>


Just add it anyway. If the field exists, it will return an error. If it doesn't exist, it will add it. If this is part of some longer script, run it with mysql --force < file.sql

<div>
<div class="content wysiwyg-content">
Hi to all,<br />
I want to check field if not exists so add a field to table.<br />
But i want to it just PURE SQL... with not php or etc...<br />
is there any way?<br />

<pre><code id="code-363875">/*
i want to add myfield  if it's not exists. just PURE SQL pls..
*/
ALTER TABLE mytable
ADD myfield varchar(20)
</code></pre>
</div>
</div>


Hi to all,
I want to check field if not exists so add a field to table.
But i want to it just PURE SQL... with not php or etc...
is there any way?

Add Column To Mysql Table

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.