title: Returned DataTable from SQL command "SHOW TABLE STATUS"
body: <p>When running the command in mySQL workbench, the command "SHOW TABLE STATUS LIKE 'tableName'" returns a single row with 23 columns. I want the "Auto_increment" column, which for reasoning, we shall say i already know i could find like so, assuming i've already connected, sent the query, and populated a DataTable;</p>
  
  <pre><code>dataTable = mDBConnector.Select("SHOW TABLE STATUS LIKE 'x'");
  MessageBox.Show(dataTable.Rows[0][15].ToString());
  //alternatively
  //MessageBox.Show(dataTable.Rows[0]["Auto_increment"].ToString());
  </code></pre>
  
  <p>However, when running the query from within my application, it returns basically nothing...the same query that returns the expected results when run from within the MySQL workbench. </p>
  
  <p>I'm sure it's not to do with permissions, as i'm testing with even root access for the sake of testing, and i know it's not how i'm retrieving data from within my application or the connection, as i use this throughout and have never had problems with it.</p>
  
  <p>Has anyone ran into this before and knows an answer?</p>
  
  <p>edit: The query i'm using is as follows (i'm using real table / column details now so i'll remove these after. Tearing my hair out here!)</p>
  
  <pre><code>SELECT * FROM information_schema.tables
  WHERE table_schema = 'bf-2300' AND table_name = 'devices';
  </code></pre>
  
  <p>In MySQL workbench, i get the following: </p>
  
  <p><img src="https://i.stack.imgur.com/uOU4k.png" alt="test"></p>
  
  <p>As you can see, it returns values correctly.
  However, when i run the query in my program and return the datatable, it does NOT contain this information and i don't know why. It's almost as if it isn't acting as a normal DataTable.</p>
  
  <p>I'm trying to get the column "auto increment" as explained above. Normally i could just pick dataTable.Rows[0]["colname"] but these contain no values - on a query which works in workbench and it's definitely not my methods for filling the DataTable as this stuff works flawlessly throughout my program. What's strange is that it's returning the query result column names, just not the information for that row.</p>