title: Mysql reverse index and query
body: <p>I have created a table with the following attributes </p>
  
  <pre><code>employee54(
      Emp_Id int, 
      First_name varchar(20),
      Middle_name varchar(20), 
      Last_name varchar(20), 
      Dept_Id int, 
      Phone_number int, 
      Address varchar(30)
  )  
  </code></pre>
  
  <p>I tried to make reverse index using this syntax  </p>
  
  <pre><code>create index emp_id_list on employee54(Emp_Id) reverse;
  </code></pre>
  
  <p>and it is showing an </p>
  
  <blockquote>
    <p>ERROR 1064 (42000): You have an error in your SQL syntax; check the
    manual that corresponds to your MySQL server version for the right
    syntax to use near 'reverse'</p>
  </blockquote>