增加字段和索引
ALTER TABLE `table_name` ADD `order` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序';
ALTER TABLE `table_name` ADD INDEX order ( `order` );
删除索引和字段
drop index index_name on table_name;
alter table table_name DROP COLUMN field_name;
判断结束和开始时间是否有重合
(
({$data['begin_time']} BETWEEN begin_time AND end_time) or
({$data['end_time']} BETWEEN begin_time AND end_time) or
( begin_time>={$data['begin_time']} and end_time<={$data['end_time']})
)
修改如果没有则添加
insert into table(fields)
(SELECT fields FROM table2 where id=xxx)
on duplicate key
UPDATE field=field (field)
INSERT 中ON DUPLICATE KEY UPDATE 插入如果存在则更新update后面的 note:AUTO_INCREMENT+1
REPLACE INTO table () VALUES(); 插入如果存在则替换 note:AUTO_INCREMENT+1