Scott Baker escreveu:
If I create the following table, and then try and insert the following
data both inserts work. It looks like the second one works (it shouldn't
because Last is NULL) because it assumes Last = ''. Is there a way I can
make it NOT assume that? If Last is not specified it should reject that
command. Is that possible?
---------------------------------------------------------------
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (
ID INTEGER PRIMARY KEY AUTO_INCREMENT,
First VarChar(30),
Last VarChar(30) NOT NULL,
Zip INTEGER
);
INSERT INTO foo (First, Last, Zip) VALUES ('Jason','Doolis',97013);
INSERT INTO foo (Last) VALUES (17423);
I think that you are confuse because in your second command you're
setting Last=17423
try this command
INSERT INTO foo (Zip) VALUES (17423);
and you'll see the message error saying that Last can't be NULL
I hope that it helps
--
Ricardo Conrado Serafim
DBA Júnior (MySQL)
URANET - www.uranet.com.br
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
