title: How to add Alter and Select together in a query?
body: <p>I have a query like:</p>
  
  <pre><code>q="""
  SELECT tb1.id, tb2.time
  FROM table1 tb1
     LEFT JOIN table2 tb2 ON tb2.pid=tb1.pid
  ALTER TABLE tb2 ADD INDEX my_col (`my_col` ASC)
  ORDER BY tb1.time DESC;
  """
  </code></pre>
  
  <p>I just found that to improve my query efficiency I need MySQL EXPLAIN. Then using workbench I realized to add a index to improve a part of query, however when I try to add this alter index to original query gives me syntax error. Do you know how can I implement EXPLAIN points like indexing to a query?</p>