mysql - 使用X创建 View X已存在表X-MySql

我正在做 ：

create view WritersCouples as
select researcher.serial_number as S1, researcher.firstname as S2
from researcher, researcher as rs
where researcher.serial_number <> rs.serial_number;

而且我收到以下错误：

Error Code: 1050. Table 'WritersCouples' already exists

我在MySql上使用工作台

谢谢 ！

最佳答案

添加以下内容：

create or replace view myview
as
select ....