Help with formatting of 1:n relationship

Hello all I have a database with a 1:n relationship as follows: Item (1) fld1 fld2 ... Item_info (n) - fld1 fld2 ... My client wants me to export these linked records into an Excel file in the following format. item.fld1 item.fld2 ... item_info.fld1 item_info.fld2 ...

Optimizing IN queries?

I have an app that joins results from a MySQL query with the results of a lookup against an external search engine, which returns its results in the form of primary-key id's of one of the tables in my database. I handle this by adding these results with an IN query. (My impression had been that

Re: Optimizing IN queries?

If you are running MySQL 5, try moving the WHERE condition into the JOIN condition, which is really where you want the filter since it's part of the join. SELECT me.id, me.quotation_id, quotation.qt, part.id, part.cit FROM cwGroup me JOIN quotation ON ( quotation.id = me.quotation_id AND

RE: Help with formatting of 1:n relationship

-Original Message- From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On Behalf Of Vikram Vaswani Sent: Monday, January 26, 2009 7:02 AM To: mysql@lists.mysql.com Subject: Help with formatting of 1:n relationship Hello all I have a database with a 1:n relationship as

Re: Help with formatting of 1:n relationship

Hi Jerry Thanks for your input on this! I'm using an excel library that accepts a SELECT as input and generates an XLS file with the records as output. I'd like to use this where possible. However I don't know if it's possible to write a SELECT that compresses a 1:n relationship into a single

Re: Help with formatting of 1:n relationship

Hi, On Mon, Jan 26, 2009 at 11:29 AM, Vikram Vaswani bacc...@vsnl.com wrote: Hi Jerry Thanks for your input on this! I'm using an excel library that accepts a SELECT as input and generates an XLS file with the records as output. I'd like to use this where possible. However I don't know if

MySQL University session on January 29: Scalability Challenges in an InnoDB-based Replication Environment

MySQL University: Scalability Challenges in an InnoDB-based Replication Environment This Thursday (January 29th), we're continuing our series of sessions on MySQL performance measuring and improvements with David Lutz' presentation titled Scalability Challenges in an InnoDB-based Replication

how can trace stored procedure usage?

I am trying to track the usage of stored procedures on our system. My solution so far is to parse the general log for call queries. This works well for procedures that are called from the command line, but the general log does not seem to report procedures called from within other procedures.

RE: how can trace stored procedure usage?

Jim- you can try to port Oracles utldtree.sql Caveat Emptor: Hasnt been worked on since 92 and is VERY buggy! Martin Gainty __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of

RE: Help with formatting of 1:n relationship

-Original Message- From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On Behalf Of Vikram Vaswani Sent: Monday, January 26, 2009 11:29 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Help with formatting of 1:n relationship Hi Jerry Thanks for your input on

Re: Help with formatting of 1:n relationship

Hi, I did consider a procedure but the problem is that the client is still using MySQL 4.x, which afaik doesn't support stored procedures. An upgrade is not something they can do at this point, as they're using s shared host so the server isn't really under their control. I think what you're

Looking for MySQL Speakers

Hello, I run PostgreSQL Conference (long announcement below). We are looking for some people to speak on why MySQL at East 09 in Philly. Anybody interested should submit a talk (or better yet Tutorial). Yes this would be a little different for a MySQL person but I believe in reaching out.