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 building CSV files with 1;2;;4;;2;9 output is not possible ?
Maybe an idea to extend the FIELDS options to enable this ...
Regards, Cor
- Original Mes
At 09:27 PM 3/31/2006, you wrote:
I have been offering free database hosting for over 4 years and I've been
doing it on a shoestring.My last MySQL server was a generic 1GHz
system with 256MB RAM running Redhat 9. The performance was surprisingly
good because the query loads were not typic
Gary - is there any way to check how many concurrent
connections you have per second out of those 14,000 users?
IIRC, each table requires at least one file handle to open
the table's data file (.MYD), plus 1 more for the index file
(.MYI) if the index file is updated.
So, I'm wondering if you
I have a program that uses MySql.
When using a MySql 5.0 server, the MySql Administrator shows in the "health"
section that the server never passes a perfectly stable limit of 9.1~9.2 KB/s of
trafic and never shows more that 1 query (per second).
Looks like some kind of configuration limitation!?
On 4/1/06, Greg Whalin <[EMAIL PROTECTED]> wrote:
> Not necessarily sure this is the problem. But if it is, it could be
> solved by switching to a different filesystem. Or, if you are using
> ext3fs, you could try enabling dir_index on the filesystem (tune2fs -O
> dir_index ... man tune2fs), whi
Hi!
I'm facing somewhat similar problems - I've stuffed about 10 thousand
databases, most of them are pretty small and not very active, and some
of the queries are extremely slow.
I've tried different filesystems, and currently I'm using
bleeding-edge reiser4 filesystem. It handles large directorie
I'm not saying it is an apache issue Gary.
I was just suggesting a way you might be able to implement
several different mysql server instances, and still have one
apache instance for your users to connect to via port 80.
Each mysql server instance could be bound to an apache
server instance v
thx's Keith, another option :)
Mike
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Saturday, April 01, 2006 10:52 AM
Subject: Re: Getting number days between 2 dates
Use SELECT DATEDIFF('new_date', 'old_date');
mysql> SELECT DATEDIFF('2006-04-01','2006-04-01');
+-
I really don't think this is an apache issue. I get the same poor
connection speeds using the mysql client.
Gary
[EMAIL PROTECTED] wrote:
I'm just wondering if it would be possible to use several
apache servers on different ports and using virtual servers,
that would each talk to a different
At 13:29 +0100 4/1/06, C.R.Vegelin wrote:
Hi everyone,
I am struggling to make a CSV file, with rows like: 1;2;;4;;2;9
where NULL values are suppressed in the CSV file.
I tried the following alternatives:
a) Select ... Into Outfile ... Fields Terminated By ';' Escaped By ''
Lines Terminated
Use SELECT DATEDIFF('new_date', 'old_date');
mysql> SELECT DATEDIFF('2006-04-01','2006-04-01');
+-+
| DATEDIFF('2006-04-01','2006-04-01') |
+-+
| 0 |
+-
I'm just wondering if it would be possible to use several
apache servers on different ports and using virtual servers,
that would each talk to a different instance of mysql, each
running on different unix sockets?
The main apache server listening on port 80 could then
redirect requests to the
Gary Huntress wrote:
>
>
> David Logan wrote:
>> mos wrote:
>>
>>> At 09:27 PM 3/31/2006, you wrote:
>>>
I have been offering free database hosting for over 4 years and I've
been doing it on a shoestring.My last MySQL server was a generic
1GHz system with 256MB RAM running Redh
On FreeBSD 5.3. MySQL 4.1.15 unix pipeline like "mysqldump ... | mysql
..." causes an auth error in the second command, even different
databases are used. What does it mean?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/
David Logan wrote:
mos wrote:
At 09:27 PM 3/31/2006, you wrote:
I have been offering free database hosting for over 4 years and I've
been doing it on a shoestring.My last MySQL server was a generic
1GHz system with 256MB RAM running Redhat 9. The performance was
surprisingly good be
- Original Message -
From: "Mike Blezien" <[EMAIL PROTECTED]>
To: "Jorrit Kronjee" <[EMAIL PROTECTED]>;
Sent: Saturday, April 01, 2006 9:00 AM
Subject: Re: Getting number days between 2 dates
Jorrit,
- Original Message -
From: "Jorrit Kronjee" <[EMAIL PROTECTED]>
To:
Sen
Mike Blezien wrote:
Jorrit,
- Original Message - From: "Jorrit Kronjee" <[EMAIL PROTECTED]>
To:
Sent: Saturday, April 01, 2006 7:46 AM
Subject: Re: Getting number days between 2 dates
Mike Blezien wrote:
Hello,
I'm sure this is a simple query but haven't come up with a good
approa
There at least two ways to accomplish this.
The easy way is to use the LIKE operator:
See
http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html
Regards
Keith
In theory, theory and practice are the same;
in practice they are not.
On Sat, 1 Apr 2006, Octavian Rasnita wrote:
> To: mys
Jorrit,
- Original Message -
From: "Jorrit Kronjee" <[EMAIL PROTECTED]>
To:
Sent: Saturday, April 01, 2006 7:46 AM
Subject: Re: Getting number days between 2 dates
Mike Blezien wrote:
Hello,
I'm sure this is a simple query but haven't come up with a good approach.
Need to get the
Mike Blezien wrote:
Hello,
I'm sure this is a simple query but haven't come up with a good
approach. Need to get the number of days between two dates. IE: today's
date: (2006-04-01 - 2006-03-05)
need to calculate the number of days between these dates.. what is the
best query statement to acc
Hello,
I'm sure this is a simple query but haven't come up with a good approach. Need
to get the number of days between two dates. IE: today's date: (2006-04-01 -
2006-03-05)
need to calculate the number of days between these dates.. what is the best
query statement to accomplish this?
TIA,
Hi everyone,
I am struggling to make a CSV file, with rows like: 1;2;;4;;2;9
where NULL values are suppressed in the CSV file.
I tried the following alternatives:
a) Select ... Into Outfile ... Fields Terminated By ';' Escaped By ''
Lines Terminated By '\r\n' ...
but this generates output
Hi,
Is it possible to create a query that searches for records which contains
words with special chars and with their english correspondents?
For example, if a user searches for "mata", I want to return all the records
that contain the words:
mata
măta
mâţa
mâţă
(just like Google does).
Is it
23 matches
Mail list logo