Last answered:

20 Nov 2022

Posted on:

19 Jun 2021

0

Error Code 1146. Table 'sales.employees' does not exist

I shutdown my computer yesterday and restarted today to work on this course.  I tried running the query for the "Using Alias" lesson, but received the Error Code 1146.  I even tried running a query that worked yesterday, but received the same error message.  On the Schema, it looks like the employees file is still there, so I don't know what is wrong, can you help?

image.png

2 answers ( 0 marked as helpful)
Posted on:

30 Jun 2021

0

Have you used the query "USE employees;" first to identify the database you are using, before typing any other query.   Please give it a try

Posted on:

20 Nov 2022

0

I think this is not the right place for this quaestion as it is related to SQL tutorials
However, you can double click on employees database on schemas section or simply put this piece of code at the beginning of your query


Use employees;

Submit an answer