contact gives empty result

2011-02-22 Thread Almar van Pel
| ++ Best regards, Almar van Pel www.makeweb.nl

RE: contact gives empty result

2011-02-22 Thread Almar van Pel
to update it with additional text. Best regards, Almar van Pel www.makeweb.nl -Original Message- From: Jaime Crespo Rincón [mailto:jcre...@warp.es] Sent: dinsdag 22 februari 2011 13:20 To: Joerg Bruehe Cc: mysql@lists.mysql.com; Almar van Pel Subject: Re: contact gives empty result 2011

RE: INSERT SELECT Problem

2005-11-23 Thread Almar van Pel \(Koekjes.Net\)
) Met vriendelijke groet, Almar van Pel -Oorspronkelijk bericht- Van: Shaun [mailto:[EMAIL PROTECTED] Verzonden: woensdag 23 november 2005 15:22 Aan: mysql@lists.mysql.com Onderwerp: INSERT SELECT Problem Hi, The following query worked fine: INSERT INTO Allocations(Project_ID, User_ID

Performance issues when deleting and reading on large table

2005-04-24 Thread Almar van Pel
seem to find out when, why or for what reason? Does anyone know? Best regards, Almar van Pel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Performance issues when deleting and reading on large table

2005-04-24 Thread Almar van Pel
don't really understand how you 'mark' the records for deletion before deleting indexes. However I'm very interested. Regards, Almar van Pel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Question regarding processes

2002-10-07 Thread Almar van Pel
/local/libexec/mysqld mysql 2594 0.0 11.8 78972 61368 ? S12:02 0:03 /usr/local/libexec/mysqld mysql 2598 0.0 11.8 78972 61368 ? S12:02 0:03 /usr/local/libexec/mysqld Best regards, Almar van Pel

Query problem in Perl

2002-08-31 Thread Almar van Pel \(Koekjes.Net\)
Hello, I was trying to create a simple perl program, where my domains where listed followed by there DNS records. But It loops once, and then ends with error DBD::mysql::st fetch failed: fetch() without execute() at test.cgi line 61. I thougt this was the easyest way to do so. But no.. Does

Query problem in Perl

2002-08-31 Thread Almar van Pel
Hello, I was trying to create a simple perl program, where my domains where listed followed by there DNS records. But It loops once, and then ends with error DBD::mysql::st fetch failed: fetch() without execute() at test.cgi line 61. I thougt this was the easyest way to do so. But no.. Does

Avanced query question

2002-02-12 Thread Almar van Pel
for hour 2. I know that my query will never return that result. We are using perl DBI. Does anyone have an idea? Kind regards Almar van Pel - Before posting, please check: http://www.mysql.com/manual.php (the manual

Is it a bug / not implemented /me ?

2002-02-12 Thread Almar van Pel
|14 | | 23 |18 | +-+---+ 23 rows in set (20.84 sec) Who can help me out on this one? Or is it not implemented, the way i use it? Thanks in advance Regards, Almar van Pel

Avanced query question

2002-02-09 Thread Almar van Pel
for hour 2. I know that my query will never return that result. We are using perl DBI. Does anyone have an idea? Kind regards Almar van Pel - Before posting, please check: http://www.mysql.com/manual.php (the manual

Is it a bug / not implemented /me ?

2002-02-09 Thread Almar van Pel
|14 | | 23 |18 | +-+---+ 23 rows in set (20.84 sec) Who can help me out on this one? Or is it not implemented, the way i use it? Thanks in advance Regards, Almar van Pel

RE: performance help required. (2G - 4G Ram upgrade)

2002-02-04 Thread Almar van Pel
for maintenance periodically to optimize these heavy tables. Regards, Almar van Pel -Oorspronkelijk bericht- Van: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 5 februari 2002 0:04 Aan: Robin Keech CC: '[EMAIL PROTECTED]' Onderwerp: Re: performance help required. (2G - 4G Ram

RE: hostname.pid

2001-12-23 Thread Almar van Pel
Hi, Check your autorisations for this file for the user mysql runs under. It does not have permissions to access the specified directory. Regards, Almar van Pel -Oorspronkelijk bericht- Van: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]] Verzonden: zondag, december 23, 2001 16.09 Aan

RE: Perl Problem!

2001-12-23 Thread Almar van Pel
it by using some breaks that print the output to a file or to the screen, so that you can see what is happening. Regards, Almar van Pel -Oorspronkelijk bericht- Van: Sascha Kettner [mailto:[EMAIL PROTECTED]] Verzonden: zondag, december 23, 2001 18.29 Aan: [EMAIL PROTECTED] Onderwerp: Perl Problem

RE: Got error 127 when reading table

2001-12-20 Thread Almar van Pel
I believe this error is assigned to a crashed table. try repair table and afterwards optimize. Regards, Almar van Pel -Oorspronkelijk bericht- Van: Martin MOKREJ [mailto:[EMAIL PROTECTED]] Verzonden: donderdag, december 20, 2001 17.24 Aan: [EMAIL PROTECTED] Onderwerp: Got error 127

Searching mailinglist

2001-12-18 Thread Almar van Pel
van Pel - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL

CPU problem

2001-12-16 Thread Almar van Pel
contains 200.000 records, wich is not so much. Does anybody know if this is normal, and if it's not, how we can fix it. We are running Slackware 7 Regards, Almar van Pel - Before posting, please check: http://www.mysql.com

RE: JOIN and Table Full error

2001-12-13 Thread Almar van Pel
join on roster Roster.playerId=Players.id order by player.plast limit 1,10 or use a left join. The above query syntax uses less memory. select * from Players,Roster where Roster.playerId=Players.id order by Players.plast limit 1,10 Regards, Almar van Pel -Oorspronkelijk bericht

RE: Problems with function sum() on float values

2001-12-13 Thread Almar van Pel
sec) == FLOAT (10,2) Regards, Almar van Pel -Oorspronkelijk bericht- Van: M. A. Alves [mailto:[EMAIL PROTECTED]] Verzonden: donderdag, december 13, 2001 16.47 Aan: Wojciech Dr¹¿ek CC: [EMAIL PROTECTED] Onderwerp: Re: Problems with function sum() on float values On Thu, 13 Dec 2001

RE: Error Message

2001-12-13 Thread Almar van Pel
as mysqld die's.) If this is the problem you have 2 reconfig mysql and correct the socket path. Regards, Almar van Pel -Oorspronkelijk bericht- Van: John Lepone [mailto:[EMAIL PROTECTED]] Verzonden: donderdag, december 13, 2001 17.50 Aan: '[EMAIL PROTECTED]' Onderwerp: Error Message I'm