RE: Returning results as a field name

ley [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 July 2006 11:25 PM To: [EMAIL PROTECTED] Cc: Mark Dale; mysql@lists.mysql.com Subject: Re: Returning results as a field name Pardon me, too early & not enough coffee, that's not quite the 'max-concat trick', but it oughtta

RE: Returning results as a field name

lues to get the other questions and their answers into the table greatly appreciated. cheers Mark Dale *** -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 July 2006 2:54 PM To: Mark Dale Subjec

Returning results as a field name

??? ++---+---+ |NAME|100|101| ++---+---+ |Mark|Yes|No | |Leigh |No |Yes| ++---+---+ cheers Mark Dale [EMAIL PROTECTED] -- MySQL General Mailing List For list

Re: SV: Problem with query

> >FEE_PAYMENTS >ID | MEMBER_ID | PRICE >1 | 2 | 500 >2 | 4 | 750 > >So as you can see, only "Torkil Johnsen" and "Madonna" has paid their fees, 500 and >750 respectively. > >Now I want to list the people that have not paid their fees... How would y

Re: Multiple Inserts

Hi all Thanks for your replies to my question about multiple updates in one query. I think Kittiphum Worachat is right in that I have designed it wrong. I couldn't get it to do what I wanted, so I reverted to single update queries. cheers Mark --- Summary of replies -- from Paul Wilso

Re: Problem with query

select * from MEMBERS,FEE_PAYMENTS where FEE_PAYMENTS.PAID = '0' and MEMBERS. MemberID = FEE_PAYMENTS. MemberID; assuming you have a field PAID, with values 0 or 1,or even YES or NO cheers Mark >I am having a small problem with a small mysql query... > >I want to make a list of: >"WHO HAS NO

Re: Running multiple queries using "MySql" client

Hi insert into mytbl (a1) values (12),(13),(14); cheers Mark --- On Mon, 15 Apr 2002, Bill Adair wrote: > Hello all, > I'm in a mysql client session and I want to do multiple inserts > into a table (or run a multi-query script etc). Thi

Re: Multiple updates

en so that it updates each of the three records? cheers Mark On Mon, 15 Apr 2002, Joseph Jude wrote: > Are you sure job_number in your script equals to all the three records and not just >one record? > > > ----- > Joseph Jude > - Origi

Multiple updates

mber'"; $result = @mysql_query($sql, $connection) or die.; and it only changes the last record. Could someone kindly tell me what I'm doing wrong. cheers Mark -- Mark Dale phone/fax: 02 6247.6731 mobile: 0403.83

Re: Multiple Inserts

Many thanks for that. cheers Mark On Mon, 15 Apr 2002, Kittiphum Worachat wrote: > Hi. > > insert into mytable (id,name,job_number,job_date) values > ('1','Mark','AA1','2002-04-15'),('2','Mark','AA2','2002-04-16'),('3','Mark', > 'AA3','2002-04-17'), > > Kittiphum Worachat,M.T. > www.ha

Multiple Inserts

alues ('2','Mark','AA2','2002-04-16') insert into mytable (id,name,job_number,job_date) values ('3','Mark','AA3','2002-04-17') - all at once if the data is the result of a form page. cheers Mark

Re: MySQL counter for HIGH traffic site

These guys have written a PHP/MySQL counter script thats available for download. http://www.kastle.net/products/php/dbcounter/ I've used their old one thats writes to a text file rather than a MySQL db and its very good also. cheers Mark Dale On Sun, 14 Apr 2002, Colin Faber

RE: limit to the number of characters allowed in a query?

pecify a bigger buffer by starting the client with mysql --set-variable=max_allowed_packet=8M. >There is a limit to the size of a packet sent to mysqld, which is >configurable. Check the manual for it, and see if you are hitting that. > >Regards > >Quentin > >>

limit to the number of characters allowed in a query?

-f in the query, but it didnt help TIA Mark Dale - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EM

RE: to output a file in table format

Hi Scott -H outputs the file nicely as a HTML bordered table, but I was more looking for a way to output the file as a "bordered" ASCII table (like a screen print below) any clues? cheers Mark Dale -Previous Message- >Have you tried the -H switch to output as HTML?