I am getting error code 105 using create view

Question

[![I am getting error code: 1050 (as you can see at from the output in the image) Table already exists, when it doesnt. Can anyone help me with this?

The question reads: Create a view called ‘computer_science_students’ for the SELECT query created under Index step ]1]1

Please don't post images of code. How much effort would it have been to copy and paste this small amount of code into the question? — Tangentially Perpendicular, May 10 '21 at 23:59

score -1 · Answer 1 · answered May 11 '21 at 00:00

-1

Sounds like you have Schroedinger's table...

you probably have a broken table. Try:

Syntax The syntax for the DROP VIEW statement in MySQL is:

DROP VIEW [IF EXISTS] view_name; view_name - The name of the view that you wish to drop. IF EXISTS - Optional. If you do not specify this clause and the VIEW does not exist, the DROP VIEW statement will return an error.

If you have sufficient permissions, delete the data files (in /mysql/data/db_name)

answered May 11 '21 at 00:00

Ashok Kumar Thangaraj

391
2
12

1

Don't just copy [someone else's answer](https://stackoverflow.com/a/3302837/14853083) and post it here as your own. Flag this question as a duplicate, if it is indeed a duplicate. – Tangentially Perpendicular May 11 '21 at 00:07
even using drop statements it still outputs error 1050 – Steve Wong May 11 '21 at 21:44
Mysql thinks it does. FLUSH TABLES; /* Clears all tables from the table cache */ DROP TABLE IF EXISTS `MyDatabase`.`MyTableName`; FLUSH TABLES; – Ashok Kumar Thangaraj May 12 '21 at 02:02

I am getting error code 105 using create view

1 Answers1