Hello Andreas,
You're not telling us what version of MySQL you're using,
so I'll have to give it a shot in the dark ...
> mysql> SHOW CREATE TABLE friends\G
> *************************** 1. row ***************************
> Table: friends
> Create Table: CREATE TABLE `friends` (
> `id` smallint(5) unsigned NOT NULL auto_increment,
> `firstname` varchar(22) collate latin1_german2_ci default NULL,
> `lastname` varchar(30) collate latin1_german2_ci default NULL,
> `nick` varchar(20) collate latin1_german2_ci default NULL,
> `birthdate` date default NULL,
> `gender` enum('m','f') collate latin1_german2_ci default 'm',
> `category` smallint(5) unsigned default '0',
----> create an index on the CATEGORY column and try again.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
