il address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Valdir Stiebe Junior" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 21, 2003 8:47 PM
Subject: Re: Hi and why
> > I don't
t;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
I just tried it myself and I get an empty set as expected.
What do you get when you do a 'select * from test'?
> -Original Message-
> From: Valdir Stiebe Junior [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 22 January 2003 5:48 am
> To: [EMAIL PROTECTED]
>
At 18:11 -0200 1/21/03, Valdir Stiebe Junior wrote:
> I'm stlll surprised that NAME = 2 returns anything. When I tried your
example, it returned no rows. I get two rows with NAME = 0, nothing
with NAME = 2. Are you sure you're not mixing up your test results?
Sorry, my mistake.
NAME =
> I'm stlll surprised that NAME = 2 returns anything. When I tried your
> example, it returned no rows. I get two rows with NAME = 0, nothing
> with NAME = 2. Are you sure you're not mixing up your test results?
Sorry, my mistake.
> NAME = 0 is a string-to-number conversion. MySQL converts th
At 16:47 -0200 1/21/03, Valdir Stiebe Junior wrote:
> 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?
I didn't end my query with the two question marks. :)
And if i put 0 instead
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, 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?
I didn't end my query with the two question marks. :)
And if i put 0 instead of (2 or any different of zero) after the equal sign
the
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 column