At 15:02 -0200 1/21/03, Valdir Stiebe Junior wrote:
Hi, i'm new at this list and to the mysql world. I'm a delphi/firebird
developer and have to acomplish some tasks using a mysql based database. So
i'm looking about how things work in mysql.
My question... i created a table TEST, with two columns, ID_TEST int(11) and
NAME varchar(50).. and added three records. This way:
1, "ppl1"
2, "ppl2"
3, <null>
ok.. why when i execute this sql, mysql return the two first rows, instead
of raising an error?
select * from TEST where NAME = 2??
I don't know why it returns the first two rows, but (assuming you didn't
really end your query with two question marks) what error are you expecting
to occur?
TIA.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php