Re: Opening .mwb file without MySql

- Original Message - From: Fred G bayespoker...@gmail.com I googled around a bunch but couldn't find a good answer to this question. Then either your google fu isn't up to it, or you don't like the right answer :-) How do I open the ERD diagram I made in MySQL WorkBench 5.2CE,

Get lowest value

Hi, I've the following data total, supplier_id, product_name, supplier_code 125,2,iPod,xyz123 100,1,iPod,abc123 145,3,iPod,1213113 245,4,iPod,12345 What query do I need to get the lowest total in this case 100 for supplier_id 1 ? Thanks Neil

I guess it was inevitable...

I noted earlier that I'm currently in an Oracle tuning course, and to my amusement, I just learned that Oracle has now also implemented an SQL result cache :-) -- What's tiny and yellow and very, very dangerous? A canary with the root password.

RE: Get lowest value

Hi Neil, Check this documentation, I think you will have no trouble to adapt it to your code http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_min -- Adrián Espinosa. Engineering Support, Wholesale Systems. Jazztel.com -Mensaje original- De: Neil Tompkins

RE: MySQL Roles and Groups

Hello Trimurthy, As far as I know, MySQL does not have such thing implemented as other database systems. -- Adrián Espinosa. Engineering Support, Wholesale Systems. Jazztel.com -Mensaje original- De: Trimurthy [mailto:trimur...@tulassi.com] Enviado el: viernes, 14 de diciembre de

Re: Get lowest value

On 2012-12-14 3:28 AM, Neil Tompkins wrote: Hi, I've the following data total, supplier_id, product_name, supplier_code 125,2,iPod,xyz123 100,1,iPod,abc123 145,3,iPod,1213113 245,4,iPod,12345 What query do I need to get the lowest total in this case 100 for supplier_id 1 ? See Within-group