"Mulugeta Maru" <[EMAIL PROTECTED]> wrote: >Table structure: > >CREATE TABLE `players` ( > `PLAYERNO` smallint(6) NOT NULL default '0', > `NAME` char(15) NOT NULL default '', > `INITIALS` char(3) default NULL, > `YEAR_OF_BIRTH` smallint(6) default NULL, > `SEX` char(1) default NULL, > `YEAR_JOINED` smallint(6) NOT NULL default '0', > `STREET` char(15) NOT NULL default '', > `HOUSENO` char(4) default NULL, > `POSTCODE` char(6) default NULL, > `TOWN` char(10) NOT NULL default '', > `PHONENO` char(10) default NULL, > `LEAGUENO` char(4) default NULL, > PRIMARY KEY (`PLAYERNO`) >) ENGINE=InnoDB DEFAULT CHARSET=latin1
I was able to repeat it on MySQL 5.0.0, but on MySQL 5.0.1 your query worked like a charm. So this bug is already fixed. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
