Disallow MySQL to accept Empty string

[jplus2]

I found out that even if you declare a column in a table in mysql as NOT NULL
it would still allow you to insert an empty string. ''.

how can I prevent this from happening in mysql?
I can always make the check in php, but, I want it to be in both ends.

Thank you in advance guys

[Nullsig]

Technically you could do it with a trigger.

You would need to execute it in MySQL console or in PHPMyAdmin

Code: Select all

CREATE TRIGGER <name of the trigger> BEFORE INSERT ON <name of table>
FOR EACH ROW BEGIN
  IF NEW.<fieldname> = ''
  THEN
    SET NEW='Error: Cannot insert record empty value for <fieldname>';
  END IF;
END
;