Trigger to fail query

How to create trigger (mysql) which to fail sql query if some of fields have no data ?

Here is my table

CREATE TABLE `new` (
  `id` int(11) DEFAULT NULL,
  `name` int(11) DEFAULT NULL,
  `phone` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Let`s say I have this quer开发者_开发知识库y

INSERT INTO new values(1, 'Bu', '');

I want that query to fail if there is no data for phone field.

phone field is declared as int so you are sending and empty char use this

INSERT INTO new values(1, 'Bu', o);

You may change the property of phone to varchar() or at least remove the NOT NULL property so you can insert null values.

INSERT INTO new values(1, 'Bu', NULL);

or

INSERT INTO new (`id`, `name`) values(1, 'Bu');