Writing SQL in mysql vs cloud9

See more:

MySQL

Hello.

I am currently learning SQL on MySQL. Instructor teaches content by using cloud9, but as my boss suggests I should learn it on MySQL. This is the point that confuses me:

When course instructors writes something that generates warning (for example, not writing something when NOT NULL is written or writing char into a int variable) it generates warning but it also inserts data into table(it automatically writes 0 for both of the examples). However, whenever I write something that generates same error, MySQL doesn't write anything on table, not names, zeros, etc. It only generates errors.

I wonder if I'm doing something wrong or is it just difference between different compilers

What I have tried:

I tried to look up for internet :(