Re: MySQL 5.0.22 and show columns bug?

"play it safe". Thus, such an approach is simply put, stupid. Ideally, 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 Typ

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

nevermind 192KB per column row displayed! 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: Slow sorting

ather than above it's actual position), but in the end is it a balance 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

RE: are autoincrement values not always increasing in innodb?

ncrementing the autoinc. 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: &

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

ll take 31 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: &

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

ANN: MyCon 2005.2.6 Released

SciBit is proud to announce the release of the newest version of MyCon, v2.6 This version includes many new and improved features as well as all reported bugfixes. Amongst others: 1. Built-in support for the new 4.1 authentication, i.e. without need for an external libmysql.dll 2. Improved

RE: Serious error in update Mysql 4.1.7

e will always be able 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.scibi

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

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 accou

RE: moving data

lem is not a concern for your local 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]&quo

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: [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: [OT] PostgreSQL / MySQL Data Dictionary

tables with thousands of records each and from start to finish takes approx. 10 seconds (our webhost and we are on different 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 recre

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

mit it. Honestly, your 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: Re: [OT] PostgreSQL / MySQL Data Dictionary

ich means the report modules made it "heavy". So a cgi would more 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

Hi All, SciBit is happy to announce the release of Mascon for Linux 0.02, a port of the popular Mascon for Windows to the Linux (I386) platform. For those interested, further information, download and installation instructions available from: http://www.scibit.com/products/software

ANNOUNCE: New MySQL product (MyLook) & Standard

Hi All, SciBit is proud to announce the release of the first version of MyLook, the personal/groupware information manager using any MySQL server as message store. This release is also the launch of a new free open database structure standard for MySQL for use as a message store. MyLook is