Hi,as per mysql-5.1 documentation, it can support one to three byte sequences for utf-8 .. but latest 6.0 code had
support for one to four byte sequence, but it is not supported anymore... do you have any plan for supporting latest utf-8 in mysql-5.1? or atleast if it is possible to backport t
I have an application that crates a users email info in MySQL every time
they login into the application. The only problem is once I remove their
account from the application/Linux, their user data remains in the MySQL
table and will eventually clutter the database. I don't know how I should or
can
I have an application that crates a users email info in MySQL every time
they login into the application. The only problem is once I remove their
account from the application/Linux, their user data remains in the MySQL
table and will eventually clutter the database. I don't know how I should or
can
Hi to every body, I am newbie for mysql lists. I have a mysql server with 2GB
of ram and Core2Duo cpu. Until today mysql server had very acceptable
performance results. But today, server is very slow. No db change, no php code
change. But I can't find the reason of this slowness.
I am using MYS
>-Original Message-
>From: OKAN ARI [mailto:okan...@aribem.com]
>Sent: Monday, July 06, 2009 10:54 AM
>To: mysql@lists.mysql.com
>Subject: Dramatic performance problem
>
>Hi to every body, I am newbie for mysql lists. I have a mysql server
>with 2GB of ram and Core2Duo cpu. Until today my
>-Original Message-
>From: Carlos Williams [mailto:carlosw...@gmail.com]
>Sent: Monday, July 06, 2009 10:53 AM
>To: mysql@lists.mysql.com
>Subject: How To Clean Old Table Data
>
>I have an application that crates a users email info in MySQL every time
>they login into the application. The
>-Original Message-
>From: Carlos Williams [mailto:carlosw...@gmail.com]
>Sent: Monday, July 06, 2009 9:59 AM
>To: mysql@lists.mysql.com
>Subject: How To Clean Old Table Data
>
>I have an application that crates a users email info in MySQL every time
>they login into the application. The
Dear All,
I have been using MySQL on FreeBSD for 3 years and encounterd a lot of problems
related to thread management. And 1 year ago, I found that my FreeBSD box does
not go well with any MySQL revision after 5.1.17-beta, because the MySQL thread
does not end although complied with LINUX_THR
On Mon, Jul 6, 2009 at 11:33 AM, Blog Tieng Viet wrote:
> Dear All,
>
> I have been using MySQL on FreeBSD for 3 years and encounterd a lot of
> problems related to thread management. And 1 year ago, I found that my
> FreeBSD box does not go well with any MySQL revision after 5.1.17-beta,
> becaus
>-Original Message-
>From: OKAN ARI [mailto:okan...@aribem.com]
>Sent: Monday, July 06, 2009 11:39 AM
>To: Jerry Schwartz
>Subject: Re: How To Clean Old Table Data
>
>Thank you Jerry Schwartz and Blog Tieng Viet,
>
>To Viet: Mysql server is up alt lease 1 year, I have setup my.cnf and
>qu
In the last episode (Jul 06), Blog Tieng Viet said:
> I have been using MySQL on FreeBSD for 3 years and encounterd a lot of
> problems related to thread management. And 1 year ago, I found that my
> FreeBSD box does not go well with any MySQL revision after 5.1.17-beta,
> because the MySQL thread
Hi,
I am using a technique described here at:
http://forums.mysql.com/read.php?20,227102,227102#msg-227102
To make results Random before applying the GROUP BY method.
The query to my table structure is this:
SELECT r.physicians_id,
(SELECT r1.id FROM physicians_images r1 WHERE
(r.physicians_id=r1
Hi,
I have numbers separated with commas saved into a TEXT Field, for example:
ROW1: 10,5,2,8,
ROW2: 2,7,9,65
ROW3: 99,100,55,10,88,
etc...
Now i want to make a query like this:
SELECT * FROM table where numbers LIKE '%8%';
The above query when executed returned the following:
ROW1: 10,5,2,8,
R
It's ugly, but this should work:
SELECT * FROM table where numbers LIKE '8,%' or numbers LIKE '%,8,%' or
numbers LIKE '%,8'
-- B
- Original Message -
From: "Highviews"
To:
Sent: Monday, July 06, 2009 6:31 PM
Subject: How to use LIKE for detecting numbers with commas?
Hi,
I ha
In the last episode (Jul 06), avrom...@whyisitthat.com said:
> From: "Highviews"
> > I have numbers separated with commas saved into a TEXT Field, for
> > example:
> >
> > ROW1: 10,5,2,8,
> > ROW2: 2,7,9,65
> > ROW3: 99,100,55,10,88,
> > etc...
> >
> > Now i want to make a query like this:
> > SEL
15 matches
Mail list logo