Insert error

[Bentley4]

Hi guys!

I've just created a table in mysql as follows:

id                              int(100)     

TStudentNumber      int(9)

SignInDate              datetime

TSuperQuestion        text     

TQuestion                text

TAnswer                  text

SignOutDate            datetime

 

But when I go to insert in phpmyadmin and write a sentence in the value field of Tquestion I get this error:

1 row(s) inserted.
Inserted row id: 5
Warning: #1366 Incorrect integer value: '' for column 'TStudentNumber' at row 1
Warning: #1264 Out of range value adjusted for column 'SignInDate' at row 1
Warning: #1264 Out of range value adjusted for column 'SignOutDate' at row 1

 

Any idea why?

[Bentley4]

Nm, found it.