Jump to content

Insert error


Bentley4

Recommended Posts

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?

Link to comment
https://forums.phpfreaks.com/topic/237039-insert-error/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.