On Sat, 17 Jan 2004, Mike Mapsnac wrote: > Is it possible to find out when the table was created? How to get information about > the table? >
You can use the unix command `stat`, the last of the 4 dates will be the creation date (in the order of Last Accessed, Last Modified, Last Inode modification, Birth Date of the file). Ex. [EMAIL PROTECTED]:/var/mysql/world# stat City.frm 1042 50097 -rw-rw---- 1 mysql mysql 230984 8702 "Dec 21 17:00:23 2003" "Dec 21 17:00:23 2003" "Dec 21 17:00:23 2003" "Dec 21 17:00:23 2003" 16384 20 City.frm In this case it shows that the table was created Dec 21. stat -f %B will give you only this data in a unixtime format, if that would suit you better. cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]