Table 'finalschedule.gc_schedule_check_v' doesn't exist

[symboly]

大佬，有事请教一下
按照你回答的那几个问题我试了，但是导入SQL 时还是提示这个问题？
1146 - Table 'finalschedule.gc_schedule_check_v' doesn't exist
[Err] INSERT INTO gc_schedule_scheduler VALUES ('4600', '13', '程明', '2015-08-05', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4601', '13', '程明', '2015-08-06', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4602', '13', '程明', '2015-08-07', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4603', '13', '程明', '2015-08-08', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4604', '4', '韩斌', '2015-08-02', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4605', '4', '韩斌', '2015-08-03', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4606', '4', '韩斌', '2015-08-04', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4607', '4', '韩斌', '2015-08-05', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4608', '4', '韩斌', '2015-08-06', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4609', '4', '韩斌', '2015-08-07', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4610', '4', '韩斌', '2015-08-08', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4611', '5', '于莎莎', '2015-08-02', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4612', '5', '于莎莎', '2015-08-03', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4613', '5', '于莎莎', '2015-08-04', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4614', '5', '于莎莎', '2015-08-05', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4615', '5', '于莎莎', '2015-08-06', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4616', '5', '于莎莎', '2015-08-07', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4617', '5', '于莎莎', '2015-08-08', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4618', '24', '李志强', '2015-08-02', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4619', '24', '李志强', '2015-08-03', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4620', '24', '李志强', '2015-08-04', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4621', '24', '李志强', '2015-08-05', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4622', '24', '李志强', '2015-08-06', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4623', '24', '李志强', '2015-08-07', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4624', '24', '李志强', '2015-08-08', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4625', '17', '赵信', '2015-08-02', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4626', '17', '赵信', '2015-08-03', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4627', '17', '赵信', '2015-08-04', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4628', '17', '赵信', '2015-08-05', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4629', '17', '赵信', '2015-08-06', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4630', '17', '赵信', '2015-08-07', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4631', '17', '赵信', '2015-08-08', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4632', '28', '新人员2', '2015-08-02', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4633', '28', '新人员2', '2015-08-03', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4634', '28', '新人员2', '2015-08-04', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4635', '28', '新人员2', '2015-08-05', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4636', '28', '新人员2', '2015-08-06', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4637', '28', '新人员2', '2015-08-07', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4638', '28', '新人员2', '2015-08-08', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4639', '27', '新人员', '2015-08-02', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4640', '27', '新人员', '2015-08-03', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4641', '27', '新人员', '2015-08-04', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4642', '27', '新人员', '2015-08-05', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4643', '27', '新人员', '2015-08-06', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4644', '27', '新人员', '2015-08-07', '', '0');
INSERT INTO gc_schedule_scheduler VALUES ('4645', '27', '新人员', '2015-08-08', '', '0');
INSERT INTO `gc_sched
[Msg] Finished - Unsuccessfully

[giscafer]

视图按照顺序创建。比如先创建gc_schedule_check_v

[symboly]

大佬，我将视图单独创建时出现这个，是版本问题还是？
谢谢

[symboly]

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near 'DROP VIEW IF EXISTS ^gc schedule. check v;
CREATE ALGORITHM=UNDEFINED DEFINER="' at line 6

[giscafer]

@symboly 如果你懂sql就可以看源码解决。不然的话就找到顺序，一个个执行里边的视图sql吧。sql也是navicat导出来的