In Relation to MaxDB, did you check out:
http://www.mysql.com/products/maxdb/docs.html
As for SAP itself, shouldn't that be the documentation kit that came with it?
Yours Sincerely
Darran Kartaschew
-Original Message-
From: Rahul Mandle [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 27 April
Sir,
What is SAP R/3 Ver 4.6c installation procedure on PC? What is
Partiontion requirement?RAM?HardDisk total requirement? C
Can any help me for this installtion procedure?
Regards
Rahul
-
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo!
Sir,
What is SAP R/3 Ver 4.6c installation procedure on PC? What is Partiontion
requirement?RAM?HardDisk total requirement? C
Can any help me for this installtion procedure?
Regards
Rahul
"Sp.Raja" <[EMAIL PROTECTED]> wrote:
Hi list,
I have 5 Databases, out of which 2 have only one table and r
Hi list,
I have 5 Databases, out of which 2 have only one table and remaining 3 have 270
tables. My data partition in disk has 50MB space. When I start inserting rows to a
particular table (which has 114 attributes), MySQL/Innodb runs out of space when
6438th row is added.
Is this an expected
Hello!
I am facing a problem when using SQL_CALC_FOUND_ROWS in certain queries.
The query where I am ordering by a column is much more slowly than the same
query NOT using SQL_CALC_FOUND_ROWS
select SQL_CALC_FOUND_ROWS * from table by date desc
- this query takes about 1.2 s
select * from table
Off the top of my head, I'm sure you'd do it like this:
SELECT
products.id,
COUNT(orders.id) AS hits
FROM
products,
orders
WHERE
orders.product_id = products.id
AND hits >= products.quantity
GROUP BY products.id
Tried that:
ERROR 1054: Unknown column 'hits' in 'where clause'
I want to be able to search for specific text in a field and return the
results for those rows. What is the best way to go about it? Do I use
the regex stuff or match?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
hi..
i am sort of confused about the SET column type... is there any place that i
can go that will give a better example of it and how to use/create it than
the manual does??
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Jeremy:
That has to be a record for fastest response with the most use. WOW!
I do use Explain but knowing this info allows me to use it in a more
intelligent way.
Thank you very much for your time.
Best Regards,
Boyd E. Hemphill
[EMAIL PROTECTED]
Triand, Inc.
www.triand.com
O: (512) 248-2
On Mon, Apr 26, 2004 at 05:17:45PM -0500, Boyd E. Hemphill wrote:
> I thought I heard at the conference that the optimizer only uses a one
> index per table in a query regardless of the number of indexes on the
> table.
>
> Is this true?
Yes.
The only exception is in a UNION, but that's best th
I thought I heard at the conference that the optimizer only uses a one
index per table in a query regardless of the number of indexes on the
table.
Is this true? Are there any more details regarding the use of indexes I
can find in the documentation? Specifically how the optimizer picks
which
On Mon, 2004-04-26 at 14:59, Matthias Eireiner wrote:
> hi there,
>
> I have a basic question:
> how can I simplify multiple OR statements in a WHERE clause where I have
> only one column to which I refer?
>
> e.g.
>
> SELECT word FROM word_table WHERE id = 1 OR id = 34 OR id = 78 OR id = 8787
On 26 Apr 2004 at 14:59, Matthias Eireiner wrote:
> how can I simplify multiple OR statements in a WHERE clause where I
> have only one column to which I refer?
>
> e.g.
>
> SELECT word FROM word_table WHERE id = 1 OR id = 34 OR id = 78 OR id =
> 8787 OR ...
You want the "IN" operator:
http:/
hi there,
I have a basic question:
how can I simplify multiple OR statements in a WHERE clause where I have
only one column to which I refer?
e.g.
SELECT word FROM word_table WHERE id = 1 OR id = 34 OR id = 78 OR id = 8787
OR ...
I thought I once read over something like this but I can't find
The main one we have noticed it on quite a few times is a mail server that
stores all of the mail in mysql. And it receives mail for about 300,000
domains. So it's normally fairly busy. Currently the load average on the
box, is 6 and for the past 10 minutes 7.41. So the load average on the box
Richard,
This is the case for using a LEFT JOIN. You want everything from the "left"
table regardless of if it has a match in the "right" table. In this case
which table is left or right depends on which table name exists to the left
of the JOIN clause.
This will show you all events regardless i
From: Richard Reina [mailto:[EMAIL PROTECTED]
> I have two tables:
>
> EVENT
> IDname date
>sponsor_ID
> 23 Sady Hawkins 2004-11-04 235
> 89 Founders Day 2004-12-21 NULL
> 87 Winter Gal
I have two tables:
EVENT
IDname date sponsor_ID
23 Sady Hawkins 2004-11-04 235
89 Founders Day 2004-12-21 NULL
87 Winter Gala 2004-01-23 NULL
SPONSOR
ID name
On Mon, Apr 26, 2004 at 04:11:37PM -0500, Donny Simonton wrote:
> We have tried the same thing, flush hosts and flush privileges did nothing.
> Refresh reload did nothing. Once the load went down the problem normally
> went away. We have tried shutting down mysql and starting it back up, that
> h
We have tried the same thing, flush hosts and flush privileges did nothing.
Refresh reload did nothing. Once the load went down the problem normally
went away. We have tried shutting down mysql and starting it back up, that
helped until the load went down. Rebooting the box usually helped, but o
On Mon, Apr 26, 2004 at 01:56:22PM -0700, Atle wrote:
>
> On Mon, 26 Apr 2004, Jeremy Zawodny wrote:
>
> > On Mon, Apr 26, 2004 at 03:44:03PM -0500, Donny Simonton wrote:
> > > Jeremy,
> > >
> > > We have also seen the problem on linux a while back; we haven't had the
> > > problem lately though.
On Mon, 26 Apr 2004, Jeremy Zawodny wrote:
> On Mon, Apr 26, 2004 at 03:44:03PM -0500, Donny Simonton wrote:
> > Jeremy,
> >
> > We have also seen the problem on linux a while back; we haven't had the
> > problem lately though.
>
> In our case, we've found that neither FLUSH HOSTS or FLUSH PRIVIE
On Mon, Apr 26, 2004 at 03:44:03PM -0500, Donny Simonton wrote:
> Jeremy,
>
> We have also seen the problem on linux a while back; we haven't had the
> problem lately though.
In our case, we've found that neither FLUSH HOSTS or FLUSH PRIVIELGES
have any effect.
Was that the case for you folks as
Jeremy,
We have also seen the problem on linux a while back; we haven't had the
problem lately though.
Donny
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 26, 2004 3:36 PM
> To: MySQL
> Cc: [EMAIL PROTECTED]
> Subject: Re: mysqld too busy to c
On Mon, Apr 26, 2004 at 01:27:08PM -0700, MySQL wrote:
>
> On Mon, 26 Apr 2004, Jeremy Zawodny wrote:
>
> > > > Yeah, we've been seeing this bug a bit too. I'm trying to isolate it
> > > > and figure out if it's a FreeBSD related problem or something more
> > > > MySQL specific.
> > > >
> > > >
On Mon, 26 Apr 2004, Jeremy Zawodny wrote:
> > > Yeah, we've been seeing this bug a bit too. I'm trying to isolate it
> > > and figure out if it's a FreeBSD related problem or something more
> > > MySQL specific.
> > >
> > > Are you using FreeBSD's native threads or LinuxThreads?
> >
> > FreeBSD
On Mon, Apr 26, 2004 at 12:21:47PM -0700, MySQL wrote:
>
> On Mon, 26 Apr 2004, Jeremy Zawodny wrote:
>
> > On Mon, Apr 26, 2004 at 11:27:46AM -0700, MySQL wrote:
> > >
> > > Hi, I have a FreeBSD 4.9-R server running 3.23.58-log and lately it's been
> > > a daily occurrence that mysqld gets so bu
Thank you Harald. That's exactly what I was looking for.
-Andy.
On Monday 26 April 2004 05:37 am, Harald Fuchs wrote:
> In article <[EMAIL PROTECTED]>,
>
> If you're sure that the people and things entries for one place are
> distinct, you can use, well, count(distinct):
>
> SELECT pl.name AS '
Michael Stassen wrote:
No, you can't use an alias in the WHERE clause. Even if you could,
you'd have a problem here. The WHERE clause is used to decide which
rows to look at in advance of any calculations. You're asking mysql
to count the rows which match the WHERE clause, but you're also as
Robert A. Rosenberg said:
> This is a re-submission of a 4/21 reply that was bounded by the list.
>
> At 09:14 -0400 on 04/21/2004, Lou Olsten wrote about Re: MySQL Website:
>
>>I have not been able to access the mysql.com server for about a day and
>> a half now from my office. From home, it's fi
On Mon, 26 Apr 2004, Jeremy Zawodny wrote:
> On Mon, Apr 26, 2004 at 11:27:46AM -0700, MySQL wrote:
> >
> > Hi, I have a FreeBSD 4.9-R server running 3.23.58-log and lately it's been
> > a daily occurrence that mysqld gets so busy that it's unable to authorize
> > connections properly. Our monito
On Mon, Apr 26, 2004 at 11:27:46AM -0700, MySQL wrote:
>
> Hi, I have a FreeBSD 4.9-R server running 3.23.58-log and lately it's been
> a daily occurrence that mysqld gets so busy that it's unable to authorize
> connections properly. Our monitoring system will report something like
> this: "Access
32 matches
Mail list logo
