Re: RE: Strange behaviour of MySQL-4.1.3b - Peihong Zhu - com.mysql.lists.win32

7 messages in com.mysql.lists.win32Re: RE: Strange behaviour of MySQL-4....

From	Sent On	Attachments
Peihong Zhu	27 Aug 2004 13:16
John Bonnett, R&D Australia	29 Aug 2004 16:19
Peihong Zhu	30 Aug 2004 11:23
Melissa Dougherty	30 Aug 2004 11:57
Peihong Zhu	30 Aug 2004 12:25
Graeme St.Clair	30 Aug 2004 14:03
Peihong Zhu	30 Aug 2004 21:30

Subject:	Re: RE: Strange behaviour of MySQL-4.1.3b
From:	Peihong Zhu (pz...@ryerson.ca)
Date:	08/30/2004 12:25:25 PM
List:	com.mysql.lists.win32

The problem is solved by:

Modifying the datafile by putting a tab character then a newline at the last
column (ie col4). instead of have newline alone. Thanks for everyone tried to help!!

----- Original Message ----- From: "John Bonnett, R&D Australia" <jbon...@sola.com.au> Date: Sunday, August 29, 2004 4:20 pm Subject: RE: Strange behaviour of MySQL-4.1.3b

I wonder if the col4 column has trailing spaces?

Does this get any records?

SELECT * FROM tableName WHERE col4 LIKE 'd%'

John Bonnett

-----Original Message----- From: Peihong Zhu [pz...@ryerson.ca] Sent: Saturday, 28 August 2004 5:47 AM To: win...@lists.mysql.com Subject: Strange behaviour of MySQL-4.1.3b

Hi,

I imported some data into a table, the format of the table is:

----------------------- col1 |col2 |col3 |col4 |

----------------------- a |b |c |d |

-----------------------

when I do:

select * from tableName where col1='a';

or:

select col4 from tableName where col1='a';

it will show the correct query results.

But if I do:

select * from tableName where col4='d';

it will return an empty set.

Does anybody know what's the cause and how to fix it?

Thanks!

Peihong