title: Notnull and empty string in My SQL
body: <p>Hy I have problem. I wanna to create table with some atributes, and some of them shoud be specified as NOT NULL.. And here comes the problem. When I insert some data into table, and when I insert '' (empty single string) it input data into table, but I dont want this... How to restrict inserting data from inputing single string or inputing nothing..</p>
  
  <p>here are my table </p>
  
  <p>CREATE TABLE tbl_Film
  (</p>
  
  <p>ID INT UNSIGNED PRIMARY KEY,</p>
  
  <p>Naziv VARCHAR(50) NOT NULL,</p>
  
  <p>Zanr VARCHAR(50) NOT NULL,</p>
  
  <p>Opis VARCHAR(150)  NULL,</p>
  
  <p>Kolicina INT UNSIGNED NOT NULL</p>
  
  <p>);</p>
  
  <p>INSERT INTO tbl_Film VALUES (1,'','Animirani','Mala ribica',2)</p>
  
  <p>This input blank data into Naziv, and I don't want that.. I need to restrict that.. </p>
  
  <p><a href="http://prntscr.com/21gfgd" rel="nofollow">http://prntscr.com/21gfgd</a></p>