event

/*drop event myevent1;
set global event_scheduler=1;
create event myevent1
on schedule every 5 second
do
insert into new_table(user_id,event_id) values (current_time(),12);*/
/*select distinct user_id,item_id
from tianchi_lbs.tianchi_mobile_recommend_train_user
where behavior_type=3 and time>'2014-12-18 14' and item_id not in (
select distinct item_id from tianchi_lbs.tianchi_mobile_recommend_train_user
where behavior_type=4);*/

delimiter $$
create trigger Testtrigger_insert after insert on `test`.`new_table` for each row begin
insert into `test`.`test_tbl`(user_id,password) values(new.user_id,new.password);
end;
$$
delimiter ;