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
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
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
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
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
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 the
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 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]
Subject: Re: Hi and why
I don't
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
: [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 know why it returns the first two rows, but (assuming
10 matches
Mail list logo