Sql Front or Query Browser?

2010-04-12 Thread alba.albetti
Sorry but for working on MySQL (I want to write query and stored procedure) are there any differences between Sql Front and Query Browser? I haven't undestood it they are the same thing or not? Could you advise me where to download both of them? Thanks! -- MySQL General Mailing List For list

Enabling slow log queries for particular db

2010-04-12 Thread RaMeSh
Hi All How can I get MySQL to only 'log-slow-queries' on specific databases instead of globally? -- Ramesh

Re: Enabling slow log queries for particular db

2010-04-12 Thread Aravinth
Hi Ramesh, As of my knowledge we can only enable slow query log globally Regards, Aravinth On Mon, Apr 12, 2010 at 4:01 PM, RaMeSh rames...@gmail.com wrote: Hi All How can I get MySQL to only 'log-slow-queries' on specific databases instead of globally? -- Ramesh

ANN: Database Workbench Pro 3, 25% discount for two more weeks!

2010-04-12 Thread Martijn Tonies
Ladies, gentlemen, Database Workbench 3.4 Pro is available with a 25% discount now! You will get the next major version for free when it is released later this month. Order now and use the coupon code DBW3X when ordering. Database Workbench is a multi-dbms development tool, for more

RE: subquery multiple rows

2010-04-12 Thread Steven Staples
If i may add (and I am no expert), but just be careful of how much you're group_concat does, as there is a group_concat_max_len value (you can override it though). I have run into this once, and couldn't figure out why i wasn't getting all my data. -- taken from the mysql site:

Re: INSERT INTO multiple tables

2010-04-12 Thread Gary
toads in it. -- Mark Twain, Pudd'nhead Wilson's Calendar __ Information from ESET Smart Security, version of virus signature database 5021 (20100412) __ The message was checked by ESET Smart Security. http://www.eset.com __ Information from ESET Smart Security

reshaping challenge

2010-04-12 Thread Mitchell Maltenfort
I have a table with two columns, ID and order. Each ID can be repeated up to 16 timers. I need to reshape it so that I have one row per ID, and columns order1, order 2,...order 16, and one number that lists how many orders there actually were. No this is not a homework assignment. I'm trying

Re: INSERT INTO multiple tables

2010-04-12 Thread Michael Dykman
Twain, Pudd'nhead Wilson's Calendar __ Information from ESET Smart Security, version of virus signature database 5021 (20100412) __ The message was checked by ESET Smart Security. http://www.eset.com __ Information from ESET Smart Security, version of virus

Re: INSERT INTO multiple tables

2010-04-12 Thread Gary
, Pudd'nhead Wilson's Calendar __ Information from ESET Smart Security, version of virus signature database 5021 (20100412) __ The message was checked by ESET Smart Security. http://www.eset.com __ Information from ESET Smart Security, version of virus signature

Re: INSERT INTO multiple tables

2010-04-12 Thread Colin Streicher
prehistoric toads in it. -- Mark Twain, Pudd'nhead Wilson's Calendar __ Information from ESET Smart Security, version of virus signature database 5021 (20100412) __ The message was checked by ESET Smart Security. http://www.eset.com __ Information from