Last answered:

31 Oct 2022

Posted on:

29 Oct 2022


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,

1 answers ( 1 marked as helpful)
Posted on:

31 Oct 2022


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.

Submit an answer