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 *

Pin It on Pinterest

Share This
Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

%d bloggers like this: