Welcome Guest, Not a member yet? Register   Sign In
incorrect integer value
#1

[eluser]rochellecanale[/eluser]
hey guys i encountered a weird problem. my problem is i always end up to this message when i attempt to insert a data.

my simple table:
Code:
CREATE TABLE test(
   id int not null auto_increment,
   message varchar(50) null,
   primary key(id)
);

my insert statement:
Code:
INSERT INTO test VALUES('','Test Message');

in my previous code it works very well but when i used my company computer i got this. Help me guys. By the way:

this insert statement works but i dont want to use it:
Code:
INSERT INTO test(message) VALUES('Test');

what should i do to prevent me in using the code above?
because im creating a membership form with different foreign keys.




Theme © iAndrew 2016 - Forum software by © MyBB