------_=_NextPart_001_01C79F01.AF6891E7
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi everyone,
=20
Is there a way to see in what version of MySQL a table was created?
=20
Your help is greatly appreciated,
=20
Mikhail Berman
Ives Group
(508)476-3257 - primary
(508)476-7007 ext.242 - secondary
mberman@ivesinc.com
=20
------_=_NextPart_001_01C79F01.AF6891E7--
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
>mberman@ivesinc.com
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 sbedberg@ucdavis.edu |
| 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/myodbc?unsub=gcdmo-myodbc@m.gmane.org
Does anyone know how to upgrade the client of a MYSQL server.
I am running php 4.3.4 with mysql 5. When I attempt to access the database
on the local machine I receive the following error message.
"Client does not support authentication protocol requested by server;
consider upgrading MySQL client"
I am not sure how to resolve this.
The error is generated in response to this simple connection, "
$db = mysql_connect('dvdserver', $username,$password) or die(mysql_error());
-----Original Message-----
From: Steve Edberg [mailto:sbedberg@ucdavis.edu]
Sent: Friday, May 25, 2007 16:16
To: Mikhail Berman; myodbc@lists.mysql.com
Subject: 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
>mberman@ivesinc.com
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 sbedberg@ucdavis.edu |
| 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/myodbc?unsub=lastsilver01@comcast.net
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org