I would like to add an index as well as the new field.
I tried this, but it failed:
Can anyone please help me get it right?PHP Code:
$sql = "ALTER TABLE `clients` ADD `new` char(1) NOT NULL default 'y',
KEY `new` (`new`)";
$result = mysql_query($sql)
or die("could not ALTER clients.". mysql_error());