mysql定时备份没有效果

一定要自动备份,不是人工的那种.要实现30秒从manager到copy的复制,manager字段较多,仅复制3个字段
创建备份表:
create table copy(
v_student1ID varchar(50) primary key not null,
v_hostIP varchar(15),
d_updateTime datetime);
定时复制:
create event myevent  on schedule every 30 second
starts current_timestamp
do
insert into copy(v_student1ID,v_hostIP,d_updateTime)
select v_studentID,v_hostIP, d_updateTime from manager;
这个代码从结果看没有执行,但也没报错.

---

SQL code:
create event myevent on schedule every 30 second
starts current_timestamp
do
insert into copy(v_student1ID,v_hostIP,d_updateTime)
select v_studentID,v_hostIP, d_updateTime from manager
where v_studentID not in (select v_studentID from copy) ;


加上where v_studentID not in (select v_studentID from copy)
否则你会主键冲突！

昨天你在群中已经问过了。

---

copy表里面主键是v_student1ID
manager表铸主键是v_studentID
这么巧,你也在这个群里面,是你回答的么昨天

---

SQL code:
create event myevent on schedule every 30 second
starts current_timestamp
do
insert into copy(v_student1ID,v_hostIP,d_updateTime)
select v_student