Last answered:

31 Oct 2022

Posted on:

29 Oct 2022

0

Resolved: Unusual error regarding "sales" database

While running the code every Screenshot of the errortime, I faced some error regarding the database 'sales' being already exists. I don't know if i should ignore this error and move forward or should I ?
Please clarify this.

Thanks in advance,
Deepak.

1 answers ( 1 marked as helpful)
Instructor
Posted on:

31 Oct 2022

1

Hi Deepak!
Thanks for reaching out.
Once you've created the table with the help of the CREATE statement, the table starts existing. Every time you try to re-run the same lines of code, SQL tries to create the same table and sees it is already there. This is why you get the error.
You can use an existing database with the help of the USE keyword.
Hope this helps.
Best,
Ivan

Submit an answer