drop view if exists info_student;
create view info_student(no,name,age,sex,department,grade)
AS
select no,name,age,sex,department,grade from student
where name = '王澜';
select * from info_student;这是运行提示
[SQL] drop view if exists info_student;
影响的数据栏: 0
时间: 0.001ms[SQL]
create view info_student(no,name,age,sex,department,grade)
AS
select no,name,age,sex,department,grade from student
where name = '王澜';
影响的数据栏: 0
时间: 0.016ms[SQL]
select * from info_student;
[Err] 1267 - Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
create view info_student(no,name,age,sex,department,grade)
AS
select no,name,age,sex,department,grade from student
where name = '王澜';
select * from info_student;这是运行提示
[SQL] drop view if exists info_student;
影响的数据栏: 0
时间: 0.001ms[SQL]
create view info_student(no,name,age,sex,department,grade)
AS
select no,name,age,sex,department,grade from student
where name = '王澜';
影响的数据栏: 0
时间: 0.016ms[SQL]
select * from info_student;
[Err] 1267 - Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
show variables like 'char%';
然后再试一下。
drop view if exists info_student;
create view info_student(no,name,age,sex,department,grade)
AS
select no,name,age,sex,department,grade from student
where name like '王澜%';
select * from info_student;
也不对啊
这是什么?不明白。。
drop view if exists info_student;
create view info_student(no,name,age,sex,department,grade)
AS
select no,name,age,sex,department,grade from student
where name like '王澜%';
select * from info_student;