title: MYSQL What triggers the information_schema data update?
body: <p>I am wondering what would trigger a mysql information_schema update as I'm running into a wall.</p>
  
  <p>My goal is to read a table's creation time and then present that data to a user. However when I run two mysql querys in php the information_schema doesn't change the creation time. For example:</p>
  
  <pre><code>///drop local table
  $delete_sql="DROP TABLE IF EXISTS bom_details;";
  if(mysql_query($delete_sql)){
      //good
  } 
  //re-create table to update schema timestamp
      $create_table_sql="CREATE TABLE IF NOT EXISTS bom_details (
    bom_id int(4) NOT NULL AUTO_INCREMENT,
    part_number varchar(86) NOT NULL,
    component_part_number varchar(86) NOT NULL,
    component_level int(2) NOT NULL COMMENT 'line number defination for parts with multiple sub-components',
    component_qty decimal(10,4) NOT NULL,
    component_um varchar(4) NOT NULL,
    PRIMARY KEY (bom_id)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;";
  if(mysql_query($create_table_sql)) {
      //worked
  }
  </code></pre>
  
  <p>However, if I drop the table in one php script, then create the table again in another php script using the same code posted above, I get a new creation time. Or if I drop the table in phpMyAdmin and run a sql create query I get a new table creation time. </p>
  
  <p>The only other thing I tried was putting a sleep timer in the PHP script to give mySQL a few seconds to register the DROP before proceeding to create the table again, but no luck there.</p>