Follow is my sql statement:
-
SELECT SUM(ol_qty) sumolqty, ol_i_id
FROM orders, order_line
WHERE orders.o_id = order_line.ol_o_id AND orders.o_id > (SELECT
MAX(o_id)-1 FROM orders) AND
NOT (order_line.ol_
Follow is my sql statement:
-
SELECT SUM(ol_qty) sumolqty, ol_i_id FROM orders, order_line
WHERE orders.o_id = order_line.ol_o_id AND orders.o_id > (SELECT
MAX(o_id)-1 FROM orders)
AND NOT (order_line.ol_i_
ing temporary; Using filesort'
1, 'SIMPLE', 'order_line', 'ref', 'PRIMARY,order_line_ol_o_id', 'PRIMARY',
'4', 'tpcw.orders.o_id', 1, ''
-
Can it be optimize
When I explain "SELECT MAX(o_id)-1 FROM orders",it tell me "Select
tables optimized away".What is it meaning?It show me good or bad?
thanks!
_
与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn
--
MySQL General Mai
NO effect :-(
From: pow <[EMAIL PROTECTED]>
To: 王 旭 <[EMAIL PROTECTED]>
Subject: Re: optimize a sql statement
Date: Mon, 18 Jul 2005 11:51:23 +0800
Do u have composite index on order_line.ol_o_id AND order_line.ol_i_id?
You could try that...
王 旭 wrote:
> Now,I make this sql st
Follow is the sql statement:
explain SELECT ol_i_id
FROM orders, order_line
WHERE orders.o_id = order_line.ol_o_id and o_id>0
ORDER BY SUM(ol_qty)DESC
Follow is the explain output:
In the mail,Pow give me a way.He advise me to build a index on
orders.o_id and orders.o_c_id.I understanding his mean is table orders join
table order_line using the index.Because orders.o_c_id be limited in the
where statemetn,so the index should be filter date before Join operation.In
this
rary; Using filesort'
1, 'PRIMARY', 'order_line', 'ref',
'PRIMARY,order_line_ol_i_id,order_line_ol_o_id,order_line_test',
'order_line_ol_o_id', '4', 'tpcw.orders.o_id', 1, 'Using where'
2, 'DEPENDENT SUBQ
x27;, 1,
'Using where; Using index'
2, 'DEPENDENT SUBQUERY', 'order_line', 'ref',
'PRIMARY,order_line_ol_i_id,order_line_ol_o_id,order_line_test',
'order_line_ol_o_id', '4', 'tpcw.orders.o_id', 1, 'Using where'
3, '
In the transaction isolation level,Database send some "duplicate entry"
message to me.
Why?
_
与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
Hello,every one.
Is there a current criterion about database function to evaluating a
database?
_
免费下载 MSN Explorer: http://explorer.msn.com/lccn/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
thanks gleb!
I know tpc constitute a performance standard for database.For
example,tpc-c,tpc-w.
Now I want to know whether there are a standard for database system
function.For example,maybe some describe in the standard : a good database
must have view manage,index manage,trigger manage et
I learn configuring the mysql server in the manul 5.3.1.I notice there is a
parameter "--large pages".Please tell my how do i alter linux system memory
pages .
_
免费下载 MSN Explorer: http://explorer.msn.com/lccn
--
MySQL Gener
Are there any difference between max_connection and max_user_connection?
thanks!
_
享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
My kernel version is 5.0.12.
When i learn the manual,i didn't find any variables in the manul when i
used "show variables".Weither there is a lack of manual updating?
thanks
_
免费下载 MSN Explorer: http://explorer.msn.com/lccn/
In mysql,server system variables's function like server option function.
How do i choosing between the server opiton and the system variables.
thanks!
_
与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn
--
MySQL General
I want to know when i need using the server option and when i need the
server system variables.In other words,can i using server system variables
replace all server options.
thanks.
From: Peter Brawley <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: 王 旭 <[EMAIL PROTECTED]&g
yes.
I look reference manual of mysql5.0.12.
For example,there a variables named "bdb_..",but i can't find these
variables used "show variables".
From: Paul DuBois <[EMAIL PROTECTED]>
To: 猝 嗥 <[EMAIL PROTECTED]>,mysql@lists.mysql.com
Subject: Re: I can't find any variables used "show vari
i execute follow sql.
select concat_ws('','d','\n','c');
the result is :
++
| concat_ws('','d','\n','c') |
++
| d
c|
++
There are no result as you said.
- Original Message -
F
Replication is a complicated process.I can't see what you do and what happened
for your computer.
From you description,i think you maybe save some old file in your entironment
and some configer parmater point to it.
So,the best way is sending you actions to me step by step and we will analyse
wh
The two querys's logic are different.Which is you need?
- Original Message -
From: "afan pasalic" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, June 04, 2008 5:50 AM
Subject: what's better query?
> Hi,
>
> I have two tables, "people" and "membership". Both have email column
> (different co
21 matches
Mail list logo
