phpeveryday.com

ALTER TABLE table_name MODIFY field_name field_type field_attribute

Example, we will change the field type of the data_employees table field position into char (50):

<?
//the example of changing MySQL database field table
//change_field.php

//database connection
mysql_connect("localhost","root","admin");
mysql_select_db("employees");

$order1 = "ALTER TABLE data_employees MODIFY position char(50)";
$add_field = mysql_db_query("employees", $order1);
if ($add_field){
	echo ("<br><br>Field position succeeds in adding");
}else{
	echo ("<br><br>Field position fails in adding");
}
?>