MySQL Forums
Forum List  »  Microsoft Access

Re: The decimal field's precision is too small--when making query by access
Posted by: Mike Hillyer
Date: September 28, 2004 09:56AM

If you moved from Access to MySQL there is a good change you have no INDEX information in the MySQL tables.

Try adding an INDEX to the Address column:

ALTER TABLE table_name ADD INDEX (Adress);

See http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html for more information.

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535

Blog: http://www.openwin.org/mike

"The Open Source movement has become a major force across the software industry, and MySQL is the world's most popular open source database."
--Fortune Magazine

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: The decimal field's precision is too small--when making query by access
3176
September 28, 2004 09:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.