Re: MySQL version

At 3:19 PM -0400 5/25/07, Mikhail Berman wrote:
>Hi everyone,
>
>Is there a way to see in what version of MySQL a table was created?
>
>Your help is greatly appreciated,
>
>Mikhail Berman
>Ives Group
>(508)476-3257 - primary
>(508)476-7007 ext.242 - secondary
>[email protected] <mailto:[email protected]>


You can check the table creation time, engine type and version using the

	show table status like 'table-name';

command; I don't know how closely the database engine version 
corresponds to the MySQL version (Eg; I created a MyISAM table this 
January using MySQL 5.0.15; the version number reported was 10). You 
could make a guess at the likely database version using the table 
creation date.

	steve

-- 
+--------------- my people are the people of the dessert, ---------------+
| Steve Edberg                                http://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center                            [email protected] |
| Bioinformatics programming/database/sysadmin             (530)754-9127 |
+---------------- said t e lawrence, picking up his fork ----------------+

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]