mysql视图命令不能保存

网络的问题。多数是网络连接异常导致。

1、首先打开电脑检查网络。

2、其次打开mysql数据库进行测试网络连接是否异常。

3、最后点击视图命令保存重新进入即可。

1.drop procedure if exists pr_even create procedure pr_even (in x int, out y int) begindeclare i intset y = 0set i = 0while i<x + 1 doif i mod 2 = 0 thenset y = y + 1 end ifset i = i + 1end while end -- 调用过程CALL pr_even(2012, @y)SELECT @y2.-- 创建临时表length()creat table tmp_student {select name from student where length(name)>3}-- 创建视图create view v_student as { select name,age from student as s,tmp_student as t_s where s.name=t_s.name}

---