mysql 查询不存在则插入

CREATE TABLE `test1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `item_no` varchar(10) NOT NULL DEFAULT '',
  `delete_flag` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1

</pre><pre>

insert into test1 (item_no,delete_flag) 
select 'aaaaa',0 from dual where not exists 
(select `item_no`,`delete_flag` 
from test1 where item_no='aaaaa' and delete_flag=0);