Bug #62093 Trying to do a select statement from a table

• Submitted: 5 Aug 2011 14:11
• Modified: 5 Aug 2011 14:14
• Reporter: Nick Fink
• Status: Not a Bug
• Category: MySQL Server: Query Cache
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any

[5 Aug 2011 14:11] Nick Fink

Description:
Trying to select a single row but I am not using the key for the table.

Example:
SELECT * FROM `application`.`state` where `State-Abbr`  = 'AL' AND 'State-ID' ='1' AND `End-Date` = '9999-12-31';
 

How to repeat:
Create a table and I am not using the index to gather the information I am looking for.

Suggested fix:
All me the program to select information by something other that the key or index.

[5 Aug 2011 14:14] Valeriy Kravchuk

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.