title: MySQL equivalent of a non clustered index
body: <p>In SQL Server, I can create a non clustered index like this:</p>
  <pre class="lang-sql prettyprint-override"><code>CREATE NONCLUSTERED INDEX idx_My_Table
  ON [dbo].[MyTable] ([my_field_1])
  INCLUDE ([my_field_2],[my_field_3],[my_field_4])
  </code></pre>
  <p>In MySQL, I create the index as</p>
  <pre class="lang-sql prettyprint-override"><code>ALTER TABLE `MyTable` 
    ADD INDEX `idx_My_Table` (`my_field_1`, `my_field_2`, `my_field_3`, `my_field_4`);
  </code></pre>
  <p>Is there an exact equivalent of the SQL Server construct in MySQL or the closest that can be changed to achieve it?</p>