Re: MySQL Searchable Mailing List Archive now up.

nder wrote: > > At 09:33 -0500 2001/12/17, Etienne Marcotte wrote: > >This is a very very good search engine for the mailing list!!! Great > >work > > Thank you! > > >Two things: > > >2- Put the "Any Date" checked by default so we don'T have t

Re: MySQL Searchable Mailing List Archive now up.

al) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifica

Re: sub selects

y: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual

Re: MySql forum or newsgroup

; > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Cana

Re: possible bug?

check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.co

Re: MySql forum or newsgroup

- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail

Re: [PHP] Performance

- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscrib

Re: MySQL on Win2000

\___/ Mogi das Cruzes - São Paulo, Brazil > <___/ www.mysql.com > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the lis

Re: SELECT'ing only 1st matching row

he manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications

Re: MySQL on Win2000

]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 --

[OT] mod_perl and last_insert_id() (Was: sequence and nextval)

ted and how can I simulate nextval the easiest way? > > > > / Thanks Henrik > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/

Re: Performance

--- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL P

[OT] When to un-normalize

ould have SELECT artistCity FROM artists WHERE artistNAME = "foo" OR artistAKA = "foo" Which would disable the index searching because of the OR right? Please give some advises!!! Etienne -- Etienne Marcotte Specifications Management - Quality Control Impe

Re: Best Free Web Panel for mySQL

equest this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Con

Re: [OT] A News Group Perhaps.

http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail > ><[EMAIL PROTECTED]> > >Trouble unsubscribing? Try:

Re: find_in_set syntax

afaik HTH, Etienne Wiliam Stephens wrote: > > At 17:40 11/12/01, you wrote: > >Can you provide your table description? > > > >You have two set colums? One called res_skills and one called > >res_skills_ma ? > > Yeah, Both are SET columns. > > Wil --

Re: ADV: Dear Future Millionaire:

Fred Dellaca, Westport, New Zealand > = > > ORDER YOUR REPORTS TODAY AND GET STARTED ON YOUR ROAD TO FINANCIAL FREEDOM ! > If you have any questions regarding this great deal please write me at >[EMAIL PROTECTED] > If you wish to

Re: [OT] A News Group Perhaps.

------- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <

Re: find_in_set syntax

(the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Ma

Re: mysql round problem

. you'll be ok with a epsilon 2 > digits smaller since you're sure that it won't affect the 4th digit > after the . > > Etienne > > Shankar Unni wrote: > > > > Etienne Marcotte wrote: > > > > > maybe you can add a small value to be sure i

Re: mysql round problem

s (and neither have any of the other DB > packages I've used recently). > > -- > Shankar. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.c

Re: mysql round problem

.php > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mai

Re: Index of SET Field

t; > How can I create an index of a SET field so that a FIND_IN_SET can search > > > for a column number rather than name? > > > > > > Is this even possible in MySQL? It might seem like a bug? > > > > > > Thanks. > > > > > >

Re: Index of SET Field

(the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacc

Re: [OT] Undescriptive subjects.

g Thompson wrote: > > On Mon, 10 Dec 2001 09:08:25 -0500, Etienne Marcotte wrote: > > >Is there a way to block "Question" "Newbie" "Please help" "Problem" and > >subjects alike? > > > > I use PMMail2000 which includes an impress

[OT] Undescriptive subjects.

#x27;m not the only one that have a little trouble handling those. Etienne p.s. this message is in no way intended to be harsh, maybe it because we are monday morning. -- Etienne Marcotte Specifications Management - Quality Control

Re: Problem

> > ----- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail &

Re: Newbie!

.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/

Re: Annoying article about MySql

sql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control

Re: efficient DELETE query - 2 tables

-- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL P

Re: Query question

lp? > > Steve > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAI

Re: Creating MySQL table w/2 primary keys

> > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > &g

Re: Query and join problem with null values

__ > Michael Delorme > GIS Manager > French Mediterranean Botanical Conservancy > mailto:[EMAIL PROTECTED] > > - > Before posting, please check: >http://www.mysql.com/manual.php (the man

Re: Comparision

Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Tr

Re: Creating MySQL table w/2 primary keys

> > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> &

Re: just moved from windows to linux mysql

IL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 -

Re: Creating MySQL table w/2 primary keys

manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscri

Re: dos prompt help

-- > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail &

Re: NULL Strings

/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperia

Re: ANN: EMS MySQL Manager 1.22 released

want... > > > >Best regards, > >EMS HiTech development team. > >http://www.ems-hitech.com > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists

Re: more than one possible column value

will use the (typeID,fileID) index if you are looking for the index of a particular file, it will use the index (fileID, typeID). this is for speed! HTH Etienne Erik Price wrote: > > On Tuesday, December 4, 2001, at 01:23 PM, Etienne Marcotte wrote: > > > CREATE TABLE fi

Re: more than one possible column value

what format that file is in (and there would be other > columns, such as "open_in" with the name of an application to open that > file with; e.g.: Photoshop for ".psd" or Illustrator for ".ai"). > > Any advice? > > Thank you, > > Erik Pric

Re: ERD

hread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001

Re: Graphical Database Information

[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before

General database design

ntpromoters where epEvtID = '3') would be perfect, assuming it selects for all the occurences where epEvtID is 3 and not just the first one. Anyways, I'm pretty sure nobody went reading this far, I'd just like some input as how you're doing your things with n:n tables. A

Re: LIMIT by column return

ation Technology Services > Indiana University Bloomington > [EMAIL PROTECTED] > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (

Re: conceptual question.

ql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --

Re: MySQL 3.23 Manual - PDF

use the manual on the screen without printing I recommend the > > pinfo viewer (ver 6.3) and mysql.info > > This provides for the ease of lynx and the speed of light. > > > > Regards, > > Thomas > > > > > > ---------

Re: MySQL 3.23 Manual - PDF

> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the lis

Another basic question - index()

a lot, Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: date type

> > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > >

Re: Please redo this horrible web page

ill be read). > > thanks > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread,

Beginner question

to be filled (or both). I can check that in my script, just asking if we can do it in mySQL Regards, Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001

Re: Newbie Question

problem.. > > Any info you need, let me know. I will provide it ASAP. > > Thanks in advance! > > CJ > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >

[OT] Comments about my DB layout

estions you may have regarding the way everything works and any comments you have. Thanks a lot, Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 -