Re: how to suppress NULL values in SELECT ... INTO OUTFILE ?

Cor, You can set the enclosing character with the ENCLOSED BY parameter. So something like ENCLOSED BY '' will remove those quotes. - Jorrit C.R.Vegelin wrote: Thanks Paul, Yes, I've tried IFNULL() to map NULL values to empty strings. But then I get 1;2;;4;;2;9 in stead of 1;2;;4;;2;9 So

Re: how to suppress NULL values in SELECT ... INTO OUTFILE ?

Thanks Jorrit, Yes, it is a combi of Paul's suggestion to use IFNULL() with the ENCLOSED BY '' option. So when using: Select IFNULL(Jan,''), IFNULL(Feb,''), ... Into Outfile ... Fields Terminated By ';' Enclosed By '' Escaped By '' Lines Terminated By '\r\n' ... I do get results like 1;2;;4;;2;9

MySQL 4.0.18 on Mac OS X 10.2.8 won't start

For some reason, MySQL 4.0.18 has suddenly stopped running and will not start anymore. It has been running for several weeks until about 5 days ago. When I tried to reach it, I discovered that it is no longer running. However, attempting to start it via the mysqld_safe script simply returns

Re: TIMESTAMP field not automatically updating last_updated field

- Original Message - From: Ferindo Middleton Jr [EMAIL PROTECTED] To: Ferindo Middleton Jr [EMAIL PROTECTED] Cc: Hank [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, March 31, 2006 7:30 PM Subject: Re: TIMESTAMP field not automatically updating last_updated field Ferindo

Select Sum with union, tricky question perhaps not for you

Hi, i have a problem to select sum from same table using UNION. The key question is there a way of combining two questions in one so the resulting objectid in query1 is only used in query 2 in a smart way. Eg. if only one object is avaliable in a search first year then only check that

Re: MySQL 4.0.18 on Mac OS X 10.2.8 won't start

Do you have some sort of visual process manager for Mac OS X that can tell you at a glance if mysqld_safe and mysql server are actually running in memory? Under linux I use a program called qps. http://www.student.nada.kth.se/~f91-men/qps/ You may already have a similar utility to view

Re: MySQL 4.0.18 on Mac OS X 10.2.8 won't start

Here are some screen snapshots of qps showing mysql server running on my machine. I tries to post these to the list, but they went over the file size limit for the mailing list. Showing mysql running in memory without using mysqld_safe script:

Re: MySQL 4.0.18 on Mac OS X 10.2.8 won't start

Sachin Petkar wrote: For some reason, MySQL 4.0.18 has suddenly stopped running and will not start anymore. It has been running for several weeks until about 5 days ago. When I tried to reach it, I discovered that it is no longer running. However, attempting to start it via the mysqld_safe

error 28 from table handler

Hi, I am getting the following error when executing a simple SELECT query which used to work: 1030 : Got error 28 from table handler I did not found that in the manual. When googleing it it seems it may be related to disk space ... The server hosting my application is running MySQL 4.0.23. My

Re: stunningly slow query

The problem with Load Data is the larger the table, the slower it gets because it has to keep updating the index during the loading process. Um, thanks. I'm not sure how Load Data got involved here, because that's not what's going on. It's a MyISAM table. Are there separate logs files?

Re: MySQL 4.0.18 on Mac OS X 10.2.8 won't start

Thanks to everyone, MySQL is back up and running. This was definitely enlightening! Sachin On 4/3/06, Eric Braswell [EMAIL PROTECTED] wrote: Sachin Petkar wrote: For some reason, MySQL 4.0.18 has suddenly stopped running and will not start anymore. It has been running for several

Re: stunningly slow query

On Sun, 2 Apr 2006, Chris Kantarjiev wrote: To: mysql@lists.mysql.com From: Chris Kantarjiev [EMAIL PROTECTED] Subject: Re: stunningly slow query The problem with Load Data is the larger the table, the slower it gets because it has to keep updating the index during the loading

Re: MySQL 4.0.18 on Mac OS X 10.2.8 won't start

On Monday, 3 April 2006 at 2:29:48 +0530, Sachin Petkar wrote: On 4/3/06, Eric Braswell [EMAIL PROTECTED] wrote: Sachin Petkar wrote: For some reason, MySQL 4.0.18 has suddenly stopped running and will not start anymore. ... There are several possible reasons for this. ... Thanks to

Re: Select Sum with union, tricky question perhaps not for you

H L [EMAIL PROTECTED] wrote on 04/02/2006 11:51:48 AM: Hi, i have a problem to select sum from same table using UNION. The key question is there a way of combining two questions in one so the resulting objectid in query1 is only used in query 2 in a smart way. Eg. if only one object

Re: MySQL 4.0.18 on Mac OS X 10.2.8 won't start

I created the my.cnf file (for some reason, it was nowhere to be found) and passed it as an argument to mysqld_safe . That's it! Works beautifully now. Thanks, Sachin On 4/3/06, Greg 'groggy' Lehey [EMAIL PROTECTED] wrote: On Monday, 3 April 2006 at 2:29:48 +0530, Sachin Petkar wrote:

Re: stunningly slow query

[EMAIL PROTECTED] wrote on 04/02/2006 05:35:59 PM: snip Can you post your show create table tbl_name statement for these tables that involve slow queries? | old_crumb |CREATE TABLE `old_crumb` ( `link_ID` bigint(20) default NULL, `dir_Travel` char(1) default NULL,