MySQL : Check if field exists

Sometimes, you need to check if a field exists in a table and if it doesn’t, you need to add it to the table and ensure that its there. Below is a snippet which you can use a reference for checking whether a field/column exists in a MySQL database table.

$tableFields = mysql_list_fields("databasename", "tablename");
		
$columns = mysql_num_fields($fields);
		
for ($i = 0; $i < $columns; $i++) {
	$field_array[] = mysql_field_name($fields, $i);
}
		
if (!in_array('list_id', $field_array)) {
	mysql_query("ALTER TABLE `tablename` ADD `fieldname` INT(11) NOT NULL DEFAULT '1';");
}

I hope that you find this useful.
The code above should give you a good idea of how to do it.

Comments

  1. By Nad

  2. By rubo77

  3. By Bruce

  4. By bawey

  5. By Achshar

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>