Re: INSERT INTO multiple tables

OST['lname']); > >>> > $street=($_POST['street']); > >>> > $town=($_POST['town']); > >>> > $state=($_POST['state']); > >>> > $zip=($_POST['zip']); > >>> > $phone=($_POST[

Re: INSERT INTO multiple tables

own, state, >>> > zip)"."VALUES('$street','$town','$state','$zip')". >>> > "INSERT INTO comments(comments)"."VALUES('$comments')". >>> > "INSERT INTO >>> >

Re: INSERT INTO multiple tables

7;)". >>> > "INSERT INTO comments(comments)"."VALUES('$comments')". >>> > "INSERT INTO >>> > contact(phone,fax,email)"."VALUES('$phone','$fax','$email')". "INSERT >

reshaping challenge

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 to

Re: INSERT INTO multiple tables

gt; > "INSERT INTO comments(comments)"."VALUES('$comments')". >> > "INSERT INTO >> > contact(phone,fax,email)"."VALUES('$phone','$fax','$email')". "INSERT >> > INTO name (fn

RE: subquery multiple rows

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: http://dev.mysql.c

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

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 infor

Re: Enabling slow log queries for particular db

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 wrote: > Hi All > > How can I get MySQL to only 'log-slow-queries' on specific databases > instead > of globally? > > -- > Ramesh >

Enabling slow log queries for particular db

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

Sql Front or Query Browser?

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 a