Hi Dan,
Thanks! Please see comments inline.
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Saturday, April 15, 2006 2:51 PM
> To: Charles Q. Shen
> Cc: 'Philippe Poelvoorde'; 'MySQL General'
> Subject: Re: MySQL cache pr
ySQL General
> Subject: Re: MySQL 4.1.11 innodb cache can't be flushed after
> restart ?
>
> 2006/4/7, Charles Q. Shen <[EMAIL PROTECTED]>:
> > Hi all,
> >
> > I am running MySQL 4.1.11 with an innoDB table holding
> about 17GB of
> > records.
7;t be flushed after
> restart ?
>
> 2006/4/7, Charles Q. Shen <[EMAIL PROTECTED]>:
> > Hi all,
> >
> > I am running MySQL 4.1.11 with an innoDB table holding
> about 17GB of
> > records. I took a few hundreds of randomly selected records
> from the
> >
Hi all,
I am running MySQL 4.1.11 with an innoDB table holding about 17GB of
records. I took a few hundreds of randomly selected records from the table
and measured the average access time:
1st test: average access time is 600ms
2nd test: average access time is 30ms
3rd test: average access time
Hi Adrian,
you can do
SELECT field_name FROM meta WHERE id IN
('13','11','7','8','9','10','12')
ORDER BY FIELD(id,'13','11','7','8','9','10','12')
/Johan
Adrian wrote:
Hi everyone,
Here is my issue:
I have this Query : SELECT field_name FROM meta WHERE id IN
Hi,
For years i've been using MySQL 3.23, but now that i'm about to
reinstall my company's web server, i've decided that it's time to go to 4.1
I've read quite a few things in the web about migrating the databases,
*including the mysql one*, but each article i read, pointed me in a
different dire
I am creating a table and would like to use auto
increment, but I would like one column to increment in
only odd numbers 1,3,5... and another column of the
same table to increment in even numbers 2,4,6...
Is it possible to do this?
Thanks,
KB
__
Do you Yahoo!?
New
Greetings all.
I have a bit of a problem here, a database i'm administering was somehow corrupted,
and i'm unable to recover it in any way. Is there any way at all to recover a corrupt
InnoDB database? (I read on innodb.com that it is impossible, but hope it is not)
When I run a query from any
I would like to auto-increment within an auto-incremented value.
For example, if I have a rental agreement(auto-incremented) and that rental agreement
becomes month-to-month.
I was thinking that I would want to track the receipts as such:
Contract # | Type | Second Auto # | Duration |payment t
I am in the process of developing a MySql database driven website but I need to know
that it is secure. Should the User Authentication Password stored in the database be
encryted? And if so, how?
Any other security tips are welcome..!
Thanks.
-
Do you Yahoo!?
Try a function called coaleace
It will return the non null value.
But i dont have the exact syntax with me nor the manual.
Hope it helps
Tommy
-Original Message-
From: Arul [mailto:[EMAIL PROTECTED]]
Sent: Wed, 05 Jun 2002 13:26
To: MySQL
Subject: Decode to Case
Hi All
I am curre
e.
Regards
Quentin
-Original Message-
From: Q [mailto:[EMAIL PROTECTED]]
Sent: Friday, 2 November 2001 4:40 p.m.
To: [EMAIL PROTECTED]
Subject: a bug or intentional? -- problem with multiple table query
I am having a problem with a query and I don't know if it is a bug or
intentio
I am having a problem with a query and I don't know if it is a bug or
intentional. Anyway any input is greatly appreciated. Here is a basic query
that is simpler than what I am dealing with but should demonstrate my problem.
Lets say:
SELECT A.1, A.2 FROM A
yeilds:
test1 test2
then:
SELECT
I have a query question that I can't seem to find an answer to. Perhaps
someone can suggest something. I will try to explain what I am trying to do:
I have what is essentially 2 queries that I would like to sum into the same
result set. I do not know if it is possible, but it would make my l
14 matches
Mail list logo
