Resolved: Unusual error regarding "sales" database
While running the code every time, 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)
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