WTO ISCO database

Does anyone has a database dump of the World Trade Organisation’s International Standard Classification of Occupation. -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com

Re: Besoin d'aide urgent

Em Sat, 11 Nov 2006 16:03:41 +0100, Yannick Landry ANTONIO escreveu: Je viens au pres de vous solliciter une aide en ce qui concerne le demarrage du serveur mysql. Eſt-ce qu’il n’y a pas de liſte francophone ? J'ai installe sur ma machine la version mysql suivant: mysql-4.0.20a-win

Re: access full-text index

On Wed, 08 Nov 2006 18:51:20 -0800, Rares Vernica wrote: Is it possible to access the Full-Text Index structures from SQL? What do you mean exactly? SQL is not intended for physical structures. -- Leandro Guimarães Faria Corcete DUTRA+55 (11) 5685 2219 http://br.geocities.com

Re: Optimize question

it on table whit all day ? That is what indexes are for. And last question, if I do a group by, I think the group by is faster on column as type INT Vs Varchar ? Not necessarily so. -- Leandro Guimarães Faria Corcete DUTRA+55 (11) 5685 2219 http://br.geocities.com

Re: www.innodb.com

they are at Oracle now? -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED] -- MySQL General

Regular expression not working as expected (documented)?

, among otherss, a string beginning with 'walt' (several, in fact). Ideas? -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASIL

Re: Regular expression not working as expected (documented)?

Em Qua, 2006-11-08 às 19:16 +0100, Christian Hammers escreveu: On 2006-11-08 Leandro Guimarães Faria Corcete DUTRA wrote: u.login REGEXP '^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*' ... But I get, among otherss, a string beginning with 'walt' (several

Re: Regular expression not working as expected (documented)?

Em Qua, 2006-11-08 às 12:53 -0600, Dan Nelson escreveu: . within brackets is treated literally anyway, so there's no need to use [.period.]. OK, I had taken the effects of - as being the effects of . REGEXP BINARY '^wa[bhkl][-_.acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*' It

Re: MyISAM vs InnoDB

yet - it's being worked on. Hm, do you mean 2PC are only documented in old IB6 stuff? -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res

Re: MyISAM vs InnoDB

you are mistaken, sadly. -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED

Re: Pushing mysql to the limits

? With a proper DBMS, you can partition the table in physical segments without complicating the logical model. Check Ingres or PostgreSQL, perhaps MySQL’s own MaxDB. -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122

Re: MyISAM vs InnoDB

Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives

Re: MyISAM vs InnoDB

a Borland shop. I usually recommend PostgreSQL, or Ingres if two-phase commits are needed. Firebird has two-phase commits. Great to know — do you have any pointers? -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11

Re: MyISAM vs InnoDB

Em Thu, 02 Nov 2006 17:30:14 +0100, Martijn Tonies escreveu: Falcon has a transactional storage engine, including Foreign Keys (Jim wouldn't do a database without em) Obviouſly. MGA Ma ze? -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador

Re: MyISAM vs InnoDB

documentation attentively, it gives you the impression everything’s A-OK with XA. And it’s not. -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res

Re: MyISAM vs InnoDB

until further notices; and SolidDB, which is still β. Choose your evil. -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASIL