does any one know the code to add another index to a mysql table??
this is the code i have to create the table so where do i put it if i want to add another index??
$query = "CREATE TABLE aq_info (uid INT not null auto_increment primary key, cust_name VARCHAR(40) not null INDEX, cust_road TEXT, cust_city TEXT, cust_post TEXT, cust_telone TEXT, cust_teltwo TEXT, cust_fax TEXT,comp_name TEXT, comp_road TEXT, comp_city TEXT, comp_post TEXT, comp_telone TEXT, comp_teltwo TEXT, comp_fax TEXT, info_note TEXT, stamp DATETIME, db_src TEXT)";
$result = mysql_query( $query) or die( "ERROR : Query failed"); // running create table powerban query
echo "Table aq_info created.<br>";
