title: How to create mysql table with two types of index from php
body: <p>I want to create one mysql table with two index, one is as INDEX and the other is as UNIQUE (on two columns). I can create/modify both of those index directly by entering phpmyadmin at later (after creating table) but can't do that from php by mysql query. I can create only one index from php by mysql query: </p>
  
  <pre><code>CREATE TABLE table (
  id int(5),
  name varchar(150),
  address varchar(150),
  telephone varchar(11)
  UNIQUE INDEX(name,address))
  ENGINE=MYISAM
  </code></pre>
  
  <p>I want to create something like this:</p>
  
  <pre><code>CREATE TABLE table (
  id int(5),
  name varchar(150),
  address varchar(150),
  telephone varchar(11),
  INDEX(id),
  UNIQUE INDEX(name,address))
  ENGINE=MYISAM
  </code></pre>
  
  <p>But How to create both index by the mysql query from php end?</p>