Re: MySQL 5.0.22 and show columns bug?

, as was the case in previous versions of MySQL, the Type column's Length should be given in context of the result, i.e. if there is an ENUM in the column list and it has the longest type description, the Type column's length should reflect its contained data size. Kind Regards SciBit MySQL Team http

[Spam-Probable]MySQL 5.0.22 and show columns bug?

Regards SciBit MySQL Team http://www.scibit.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Slow sorting

between speed and the odd mis-ordered record. Kind Regards SciBit MySQL Team http://www.scibit.com MySQL Products: http://www.scibit.com/products/mycon http://www.scibit.com/products/mysqlcomponents -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: are autoincrement values not always increasing in innodb?

SciBit MySQL Team http://www.scibit.com MySQL Products: http://www.scibit.com/products/mycon http://www.scibit.com/products/mysqlcomponents http://www.scibit.com/products/mysqlx http://www.scibit.com/products/mascon -Original Message- From: Frank Sonntag [EMAIL PROTECTED] To: mysql

RE: Re: error

. max_allowed is 1Mb and you are sending a 2Mb SQL statement. Also the client write and read timeout also causes this error, i.e. when you are doing a query which takes longer than say 60 seconds and your read timeout is set for a default 30 seconds. Kind Regards SciBit MySQL Team http://www.scibit.com

RE: Definition of password hashing algorithm in 4.1.7

years :) Kind Regards SciBit MySQL Team http://www.scibit.com MySQL Products: http://www.scibit.com/products/mycon http://www.scibit.com/products/mysqlcomponents http://www.scibit.com/products/mysqlx http://www.scibit.com/products/mascon -Original Message- From: Mike Moran [EMAIL

RE: find all records with more than one occurrence

Hi, How can I check all duplicated rows out from a large table? The values are not keys so they may have more than one occurrence. Thanks for your help. Regards, CHAN Chan, what about using DISTINCT in the select? .. or am I missing something? Kind Regards SciBit MySQL Team

ANN: MyCon 2005.2.6 Released

/viewtopic.php?t=164 For free downloads and/or free versions, see: http://www.scibit.com/products/mycon Kind Regards SciBit MySQL Team http://www.scibit.com MySQL Products: http://www.scibit.com/products/mycon http://www.scibit.com/products/mysqlcomponents http://www.scibit.com/products/mysqlx http

RE: Different password() function ?

Hi Ady, See your OLD_PASSWORD MySQL option in your MySQL Docs. Or the following articles: http://dev.mysql.com/doc/mysql/en/MySQL_4.1_Nutshell.html http://forum.scibit.com/viewtopic.php?t=195 Kind Regards SciBit MySQL Team http://www.scibit.com MySQL Products: http://www.scibit.com/products

RE: Serious error in update Mysql 4.1.7

to find their records independent of the data contained in the table. Kind Regards SciBit MySQL Team http://www.scibit.com MySQL Products: http://www.scibit.com/products/mycon http://www.scibit.com/products/mysqlcomponents http://www.scibit.com/products/mysqlx http://www.scibit.com/products/mascon

ANN: MyCon 2004.2 released

Hi All, SciBit is happy and proud to announce the 2004.2.0 release of MyCon. Upgrading your current version is free and you can download the new MyCon Pro version at: http://download.scibit.com/release/mycon/mcp.exe What's new summary: * One of the newest features, and by all accounts a

RE: moving data

computer), that way you have all your data backed up for just in case. Kind Regards SciBit MySQL Team http://www.scibit.com -Original Message- From: J S [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] CC: Subject: moving data Sent: Thu, 02 Sep 2004 12:38:30 GMT Received: Thu

ANN: MyCon 2004.1.1 Released

SciBit is happy and proud to announce the 2004.1.1 release of MyCon. If you already have a registered copy, upgrading your current version is free and you can download the new MyCon Pro version (or for trial purposes): http://download.scibit.com/software/mycon/mcp.exe FreeMyCon is completely

RE: Re: [OT] PostgreSQL / MySQL Data Dictionary

backups is only limited by your imagination. Kind Regards SciBit MySQL Team http://www.scibit.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [OT] PostgreSQL / MySQL Data Dictionary

continents). And to set all this up initially took a massive.. one click! If our ISP drops our database by mistake, it will take us all of two seconds to recreate a complete snapshot of the database using the latest target script. Kind Regards SciBit MySQL Team http://www.scibit.com -- MySQL

RE: [OT] PostgreSQL / MySQL Data Dictionary

-w, --where=nameDump only selected records; QUOTES mandatory! :) The more options the merrier for MySQL and the end-users :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Re: [OT] PostgreSQL / MySQL Data Dictionary

than likely fall into the 200Kb footprint range, instead of 1Mb. Kind Regards SciBit MySQL Team http://www.scibit.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ANN: Mascon for Linux 0.03 released

Hi All, SciBit would like to announce the latest release of Mascon for Linux 0.03. For those interested please check: http://www.scibit.com/Products/Software/Mascon4Linux Kind Regards SciBit MySQL Team http://www.scibit.com

ANN: Mascon for Linux 0.02 released

editing, user and privilege management, dump functionality and much more. Kind Regards SciBit MySQL Team http://www.scibit.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com