If you use just 1 OR you will force a table scan and slow everything down ?
- Original Message -
From: Mysql List [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Sent: 26 September 2001 20:06
Subject: How many OR, AND in a query?
Hi,
How many OR or AND can I put in a select query
Hi
Do you have 'the book' MySQl if so read pages 464-465. if not try deleting
the anonymous entries in the user table. They can cause this error.
Hope that helps
Richard
- Original Message -
From: David Iyoha [EMAIL PROTECTED]
To: Adams, Bill TQO [EMAIL PROTECTED]
Cc: [EMAIL
Hi
Look at the sample database.
try this
create.sql==
# Change user and password to add privileges for different user.
# Note that user with no hostname given is equivalent to specifying
# % as the hostname.
GRANT ALL ON pool.* TO contact;
DROP DATABASE IF