Sorry, correcting my last email, the sql result the two rows when i use 'NAME = 0'.
----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Valdir Stiebe Junior" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 21, 2003 4:33 PM Subject: Re: Hi and why > 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
