Re: Using indexes on mysql.

2002-06-13 Thread Day Irmiter
Consider the usefulness of a book's index. Instead of scanning several hundred pages of text to find a particular word you look at an alphabetical list that tells you the locations in which the word is found. It's a lot faster, yes? > Here's my Qu : What's the use of using indexes in mysql ? Why

Re: Replication zwischen MYSQL und MS Access 97(2000)

2002-06-13 Thread Day Irmiter
See www.mysqlfront.de. This program will convert Access databases to mySQL fairly painlessly. - Original Message - From: Wouter van Vliet <[EMAIL PROTECTED]> To: N. Ott <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: Wouter @ Witbier <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 3:26 AM

Re: ENUM query question

2002-06-13 Thread Day Irmiter
Maybe you should say WHERE category LIKE 'Gambling' - Original Message - From: Jeff Field <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 11:42 AM Subject: ENUM query question > I have a quick question regarding queries that involve values in ENUM > columns.

housekeeping

2002-06-10 Thread Day Irmiter
Each time I post to the MySQL list I get two messages as follows. - Original Message - From: Mailer-Daemon <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 10, 2002 9:10 PM Subject: NDN: Re: Here's something > Sorry. Your message could not be delivered to: > > mailing lis

Re: Here's something

2002-06-10 Thread Day Irmiter
Looks okay to me except table teach_classes should have a unique id for each record. teach_clases (taught_id, class_id, teach_id) Over the long term, the same class probably will be taught more than once and the same teacher probably will teach more than one class so neither class_id nor teach_i

RE: support UTF-8

2002-06-10 Thread Day Irmiter
You may find the Access conversion easier to do using MysqlFront, downloadable at www.mysqlfront.de. - Original Message - From: Egor Egorov <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 10, 2002 8:08 AM Subject: Re: FW: RE: support UTF-8 > Mehdi, > Saturday, June 08, 2