Table X already exists using Create view X as - MySql

Question

I'm doing :

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;

And i'm getting the following error :

Error Code: 1050. Table 'WritersCouples' already exists

I'm using workbench over mySql

Thank you !

Answer 1

Add the following:

create or replace view myview
as
select ....