Vaibhav Difference between amount <> null and amount is not null

What is the difference between the following sql queries written to >extract tuples with the field amount having non null value: > select loan_number from loan where amount <> null (It >returns >an empty set) > select loan_number from loan where amount is not null(It >returns the exp

Problem with LOAD LOCAL DATA INFILE

I am using MySQL version 3.23.11-alpha on Win98. I have created a database with a table borrower whose description is as follow: mysql> describe borrower; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +--