Re: table info
Mike Mapsnac [EMAIL PROTECTED] wrote: Is it possible to find out when the table was created? How to get information about the table? SHOW TABLE STATUS command provides info about table: http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: table info
I think that main disadvantage of this command is thah it works for the database but not for specific table. So if a database has 200 tables, find result for specific table is not an easy task. From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: table info Date: Mon, 19 Jan 2004 14:10:37 +0200 Mike Mapsnac [EMAIL PROTECTED] wrote: Is it possible to find out when the table was created? How to get information about the table? SHOW TABLE STATUS command provides info about table: http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Rethink your business approach for the new year with the helpful tips here. http://special.msn.com/bcentral/prep04.armx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: table info
I think that main disadvantage of this command is thah it works for the database but not for specific table. So if a database has 200 tables, find result for specific table is not an easy task. Easy: SHOW TABLE STATUS LIKE 'table_name' Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: table info
On Mon, 19 Jan 2004, Mike Mapsnac wrote: I think that main disadvantage of this command is thah it works for the database but not for specific table. So if a database has 200 tables, find result for specific table is not an easy task. SHOW TABLE STATUS LIKE 'tablename'\G cheers, Tobias From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: table info Date: Mon, 19 Jan 2004 14:10:37 +0200 Mike Mapsnac [EMAIL PROTECTED] wrote: Is it possible to find out when the table was created? How to get information about the table? SHOW TABLE STATUS command provides info about table: http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Rethink your business approach for the new year with the helpful tips here. http://special.msn.com/bcentral/prep04.armx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: table info
Mike Mapsnac [EMAIL PROTECTED] wrote: I think that main disadvantage of this command is thah it works for the database but not for specific table. So if a database has 200 tables, find result for specific table is not an easy task. If you want to get info about specific table, you can just do: SHOW TABLE STATUS LIKE 'table_name'; From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: table info Date: Mon, 19 Jan 2004 14:10:37 +0200 Mike Mapsnac [EMAIL PROTECTED] wrote: Is it possible to find out when the table was created? How to get information about the table? SHOW TABLE STATUS command provides info about table: http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: table info
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]
