[![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
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)