php mysql防止提取相同数据_从php输入时，防止mysql数据库中的数据重复

查看David OBrien的评论HERE ......

基本上因为在MySQL中没有CREATE INDEX IF NOT EXISTS他建议使用这种程序：

DELIMITER $$

DROP PROCEDURE IF EXISTS `create_index_if_not_exists`$$

CREATE DEFINER=`user`@`%` PROCEDURE `create_index_if_not_exists`(table_name_vc varchar(50), index_name_vc varchar(50), field_list_vc varchar(200))

SQL SECURITY INVOKER

BEGIN

set @Index_cnt = (

select count(1) cnt

FROM INFORMATION_SCHEMA.STATISTICS

WHERE table_name = table_name_vc

and index_name = index_name_vc

);

IF ifnull(@Index_cnt,0) = 0 THEN set @index_sql = concat('Alter table ',table_name_vc,' ADD INDEX ',index_name_vc,'(',field_list_vc,');');

PREPARE stmt FROM @index_sql;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

END IF;

END$$

DELIMITER ;然后把它称为

call create_index_if_not_exists('tablename','indexname','thisfield,thatfield');