Re: Fwd: Re: Help Save MySQL

2009-12-18 Thread Bruno B. B. Magalhães
suggest using Monty (if he aggrees) letter as base and start spreeding the word. Bruno B. B. Magalhães Sócio-Diretor de Negócios e Tecnologia BLACKBEAN CONSULTORIA Rua Real Grandeza 193/210, Botafogo Rio de Janeiro, RJ, 22281-035, Brasil +55 (21) 9996-1093 +55 (21) 2266-0597

Fwd: Re: Help Save MySQL

2009-12-18 Thread Bruno B. B. Magalhães
ing to the media like TechCrunch.com, BusinessWeek, ZD.Net, etc. Without society's engagement we won't acomplish anything! Regards, Bruno B. B. Magalhães Sócio-Diretor de Negócios e Tecnologia BLACKBEAN CONSULTORIA Rua Real Grandeza 193/210, Botafogo Rio de Janeiro, RJ, 22281-035, B

SssS Generic modeling...

2008-10-25 Thread Bruno B. B. Magalhães
:00:00','0','-00-00 00:00:00','1','-00-00 00:00:00'); What would be followed by (a trigger perheaps or the application it self) the queries: ALTER TABLE `TB1` ADD `CL11` INTEGER(20) NOT NULL DEFAULT NULL AUTO_INCREMENT

Re: Practical hierarchies

2008-04-29 Thread Bruno B B Magalhães
e or recursive query? For example: SELECT RECURSIVE * FROM ProductsCategories USING ProductCategoryParentID = ProductCategoryID Is this syntax factive? Best regards, Bruno B. B. Magalhães BLACKBEAN CONSULTORIA Rua Real Grandeza 193/210, Botafogo Rio de Janeiro, RJ, 22281-035, Brasil +55 (2

Practical hierarchies

2008-04-29 Thread Bruno B B Magalhães
logsCategoriesIndexD` (` CatalogCategoryCreatedOn `,`CatalogCategoryModifiedOn`,`CatalogCategoryRemovedOn`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 Pros: SQL friendly so much less processing and queries required, very export / inport friendly Cons: Fixed deep and a little bit more difficult

Re: Performance

2008-04-22 Thread Bruno B. B. Magalhães
s On Apr 22, 2008, at 3:21 PM, Perrin Harkins wrote: On Tue, Apr 22, 2008 at 11:41 AM, Bruno B. B. Magalhães <[EMAIL PROTECTED]> wrote: I thing the most problematic part of those queries are the date range part, should I use a different index only for this column to maintain the index

Performance

2008-04-22 Thread Bruno B . B . Magalhães
Hi everybody, I am back to this list after a long period away due to work time restrictions... I have great news and a few interesting applications that I will release to the mysql community very soon, most probably as open source. But now I have a performance problem with a client of min

Re: making graphs with MySQL data

2007-01-16 Thread Bruno B B Magalhães
plugin installed, nothing more nothing less. And just to remember, flash is now present on 99.6% of the world´s computers. Take a look at their site, and specially on demo section. Best Regards, Bruno B B Magalhães On Jan 16, 2007, at 2:08 PM, C.R.Vegelin wrote: Hi Bruno, Thanks a lot !! I feel

Re: making graphs with MySQL data

2007-01-16 Thread Bruno B B Magalhães
. And before anyone start pointing the fingers, I don´t have any affiliation with InfoSoft Global in any shape or form, besides been a happy client. :o) Best Regards, Bruno B B Magalhães On Jan 16, 2007, at 11:43 AM, C.R.Vegelin wrote: Thanks El Cuy, Joshua, Ryan, Let me be more specific

CRM: Labels instead of specific atributes

2006-06-10 Thread Bruno B B Magalhães
hold statistical data. Anything that I´ve just said make any sense? :) Is anybody who is a large scale CRM developer interested in exchanging thoughts? Best Regards to you all, Bruno B B Magalhães -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Best practices

2006-04-11 Thread Bruno B B Magalhães
Hi guys I need some help with two things... I have the following table: CREATE TABLE `telephones` ( `contact_id` int(20) unsigned NOT NULL default '0', `telephone_id` int(20) unsigned NOT NULL default '0', `telephone_country_code` char(5) NOT NULL default '', `telephone_area_code` char(5

Country codes

2005-11-20 Thread bruno b b magalhães
Hi guys, I know it's a little bit off-topic, but does some one have a list with all countries of the world and their respective ISO codes (Like BRA, US, UK, etc.) and also their international calling codes (Like +55, +1, +32)? Thanks a lot, Bruno B B Magalhaes -- MySQL General Mailing Li

Re: BIIIIIIIIIIG query (I GOT IT, well I think so!)

2005-11-19 Thread bruno b b magalhães
.contact_id ORDER BY contacts.contact_name ASC == Course this is the final version outputted from PHP module before it's send to the database. Best Regards, Bruno B B Magalhaes On Nov 19, 2005, at 6:17 PM, bruno b b magalhães wrote: Another test. I tried just to j

Re: BIIIIIIIIIIG query

2005-11-19 Thread bruno b b magalhães
ROTECTED]> To: "bruno b b magalhães" <[EMAIL PROTECTED]>; "MySQL List" Sent: Saturday, November 19, 2005 12:05 PM Subject: Re: BIIIIIIG query At 12:51 -0200 11/19/05, bruno b b magalhães wrote: Hi guys, I need some help with an query that I know I must use joi

Re: BIIIIIIIIIIG query

2005-11-19 Thread bruno b b magalhães
joins beyond the statement syntax the last time I looked - many months ago - but MySQL uses standard SQL so _any_ SQL tutorial should have some good examples for you, even if it is intended for DB2 or Oracle users. When you understand the concepts and syntax, you should be able to app

BIIIIIIIIIIG query

2005-11-19 Thread bruno b b magalhães
Hi guys, I need some help with an query that I know I must use joins, but I can't figure out how to. The problem is, when the contact has an address, phone and email it works just fine, but I want it to display those how doesnt also! Could someone with JOINs experience help me? And one