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
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
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,
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
Jorrit,
- Original Message -
From: Jorrit Kronjee [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
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:
Mike Blezien wrote:
Jorrit,
- Original Message - From: Jorrit Kronjee [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
- Original Message -
From: Mike Blezien [EMAIL PROTECTED]
To: Jorrit Kronjee [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Saturday, April 01, 2006 9:00 AM
Subject: Re: Getting number days between 2 dates
Jorrit,
- Original Message -
From: Jorrit Kronjee [EMAIL PROTECTED]
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
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:
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 Redhat 9. The performance
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
Use SELECT DATEDIFF('new_date', 'old_date');
mysql SELECT DATEDIFF('2006-04-01','2006-04-01');
+-+
| DATEDIFF('2006-04-01','2006-04-01') |
+-+
| 0 |
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
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
thx's Keith, another option :)
Mike
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
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
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
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), which
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!?
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
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
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 Message -
23 matches
Mail list logo
