Jump to content

[SOLVED] mysql table creation date


dennismonsewicz

Recommended Posts

show databases

 

gives me the databases I've created, as well as "information_schema". In that database, there's a "tables," uhm, table.

 

It's got info about all the databases and their tables, including a column called "create_time", which will tell you what you want.

here is the code I am using:

 

$t = mysql_query("SHOW users STATUS")or die(mysql_error());
print_r($t);

 

This is the error I am getting:

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 'users STATUS' at line 1

hmmm now I am getting:

 

Resource id #4

 

when I print_r the mysql_query

 

You're clearly having a bad hair day

$t = mysql_query("SHOW TABLE STATUS LIKE 'users'")or die(mysql_error());
while (($r = mysql_fetch_array($t)) !== false) {
   print_r($r);
}

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.