gards
--
Are you MySQL certified? -> http://www.mysql.com/certification
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full
//www.mysql.com/certification
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\
Joshua,
Joshua Spoerri wrote:
On Tue, 5 Aug 2003, Alexander Keremidarski wrote:
MySQL will never use any index for small tables. With just few rows using index
adds overhead only. Table scan is faster in such cases. This is docummented behaviour.
is 100,000 rows small? my simple OR queries
m/?ref=msal
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com
--
MySQL General Mailin
ql.com/?ref=msal
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
real data.
--
MySQL Conference and Expo 2003 http://www.mysql.com/events/uc2003/index.html
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTEC
h provides much better flexibility and is
more natural than mysqld starting option.
If you still have concerns, please don't hesitate to share them with us.
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /
it to filesystem checks. It is admin to decide if he can handle
it with live server or not.
--
Best regards
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]>
/ /|
[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
--
Best regards
--
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ __
/ |/ /_ __/ __/ __ \/
gle statement in MySQL :)
--
Best regards
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com M: +359 88 231668
+-+
| truncate(199.20,10) |
+-+
| 199.19 |
+-+
--
Best regards
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
;initialize' each variable twice in every statement like:
SELECT (@var1 := 1999) as ... WHERE YEAR(filing_date) = (@var1 := 1999)
but don't believe it will save you any effort.
--
Best regards
--
For technical support contracts, visit https://order.mysq
ontracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
/mysql_db /var/lib/mysql/user1_db
--
Best regards
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_
s will be very small and fast index.
I want to mention also that in your first posting table dancetitles has
no index at all on title column.
>
>Donna
>
--
Best regards
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/
nglish)
mysql> SELECT date_col FROM your_table WHERE date_col BETWEEN '2002-02-08' AND
'2002-02-12';
will be valid statement :)
--
Best regards
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr
tracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
Hi,
Jasmin Bertovic wrote:
>For example;
>
>SELECT number as current_day, (number - )
>as change_from_prev_day FROM TABLE ORDER BY DATE
>
> is the reference that I need from the
>previous row.
>
>Am I missing something simple or do I have to do this
>outside of MYSQL?
>
>
1. Yes you are missing
e new
value', );
Where can be any valid expression
--
Best regards
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]>
/ /|_/ / // /
+---+---+-+
3 rows in set (0.00 sec)
Are you satisfied? :)
Detailed analisys of this technique can be found in a great (MUST read)
article at:
http://www.mysql.com/articles/wizard/index.html
http://www.devshed.com/Server_Side/MySQL/MySQLWiz/page1.html
--
Best regards
--
For t
01-30';
--
Best regards
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_
Description:
When WHERE clause contains OR mysql don't any keys and don't perorm
validity check even.
USE KEY directive does not change this.
How-To-Repeat:
create table t (
a int unsigned,
b int unsigned,
key(a),
key(b));
insert about 2000 random rows
select count(*) from t;
2048
1. C
23 matches
Mail list logo
