Hi,
Creating a table with a not null field, and then trying to insert it doesn't
raise an error 'Column XXX cannot be null'
Well, this was the steps (sql to bypass filter) i did:
1. create table TEST ( id_test integer, name varchar(50) not null );
2. insert into TEST (id_test, name) values (1, 'pp
> 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
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
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