Re: Stupid Question about Tables

[Peter Brawley]

You'd be better off using Connector/NET 5.

Here's one way:

public Int32 TableExists( string db, string table, MySqlConnection conn ) {
  object obj = null;
  MySqlCommand cmd = new MySqlCommand();
  try {
    cmd.CommandText = "SELECT COUNT(*) FROM information_schema.tables " +
                      "WHERE table_schema = '" + db + "' " 
                      "AND table_name = '" + table + "'";
    cmd.Connection = conn;
    obj = cmd.ExecuteScalar();
  }
  catch ( MySqlException ex ) {
    MessageBox.Show( ex.Message + Environment.NewLine + ex.StackTrace.ToString(); );
  }
  finally {
    cmd.Dispose();
  }
  return Int32.Parse( obj.ToString() );
}

PB