Re: Searching on Two Keys with OR?

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

Re: Searching on Two Keys with OR?

m/?ref=msal __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria <___/ www.mysql.com -- MySQL General Mailin

Re: Searching on Two Keys with OR?

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

Re: RADIUS is a Wh*%@

//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 /_/ /_/\_, /___/\___\

Re: UPDATE with WHERE+ORDER+LIMIT error(?) - test shell script (fwd)

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

Re: MySQL 4.0.5(a) is released

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/ __ ___ ___ ____ __ / |/ /

Re: optimizer bug in the index used by mysql/Innodb in the search

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

Re: How get the columns that are between an interval?

01-30'; -- Best regards -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_

Re: MySQL to Excel ?

+---+---+-+ 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

Re: finding values in TableA not in TableB

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]> / /|_/ / // /

Re: User Variables and Previous Row Question

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

Re: LOAD DATA LOCAL error

tracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria

Re: display days between two dates?

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

Re: Trouble with indexing

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/ __ ___ ___ __ /

Re: quota on mysql

/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 /_/ /_

Re: moving databases question...

ontracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria

Re: Bug or error in SQL syntax - Specifying and using a user variableinside a single select query

;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

Re: funny truncate "problem"

+-+ | truncate(199.20,10) | +-+ | 199.19 | +-+ -- Best regards -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /

Re: MySQL load problems - gcc-2.96?

, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Keremidarski <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria <___/ www.mysql.com M: +359 88 231668

Re: NOW()

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

Re: [BUG] CONCAT_WS + GROUP BY display problem

[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 __ ___ ___ __ / |/ /_ __/ __/ __ \/

Re: Locking TABLES for myisamchk, please help!!

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]> / /|

SQL optimizer and OR - bug or misconcept?

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