The two querys's logic are different.Which is you need?
- Original Message -
From: afan pasalic [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
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
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 -
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
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
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]
CC: mysql
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 variables
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
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
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:
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:
', '', '', '', '', '', '', , 'Select tables optimized away'
--
Is the performance of sql statement be increased?
From: Sebastian [EMAIL PROTECTED]
To: 王 旭 [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], mysql@lists.mysql.com, [EMAIL PROTECTED]
Subject: Re
it.I don't know the
reason.
Are you have any better way?
From: [EMAIL PROTECTED]
To: 王 旭 [EMAIL PROTECTED]
CC: mysql@lists.mysql.com,[EMAIL PROTECTED]
Subject: Re: optimize a sql statement
Date: Tue, 19 Jul 2005 16:10:18 -0400
王 旭 [EMAIL PROTECTED] wrote on 07/18/2005 03:12:28 AM
. Estimating Query Performance in
help.But i can't understand.
thanks
From: 王 旭 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: mysql@lists.mysql.com, [EMAIL PROTECTED]
Subject: Re: optimize a sql statement
Date: Thu, 21 Jul 2005 18:46:32 +0800
Thank you SGreen.But i can'optimize the sql statement
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
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 statement to easy
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_id0
ORDER BY SUM(ol_qty)DESC
Follow is the explain output:
,order_line_ol_o_id', 'PRIMARY',
'4', 'tpcw.orders.o_id', 1, ''
-
Can it be optimized?
From: 王 旭 [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: optimize a sql statement
Date: Sat, 16 Jul 2005 18:24:15 +0800
Follow is my sql statement
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
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
21 matches
Mail list logo