Follow this topic

Last answered:

25 Jun 2022

Posted on:

21 Jun 2022

0

database error when executing create statement

in SQL / Creating a Database - Part I

I executed the code correctly, but the sales database cannot be created because it already exists so I am getting an error. What should I do?

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

25 Jun 2022

0

Hi Kristin!
Thanks for reaching out.

This is because you have already created this table. Please, remove the code which creates the table and it will be fine.

Hope this helps.
Best,
Tsvetelin

Submit an answer

related questions

0

16

14. SQL JOINs - Error Code: 1055 (only_full_group_by)

1

14

Resolved: employees.sql database not found in resources

0

14

error code 1140 : in aggregated query without group by

Michael A. Ingram

1

12

Loading my previous database into a new installation of MySQL

Christopher Watts

1

12

Error Code: 1364. Field 'customer_id' doesn't have a default value

3

12

sample employee Database not found as resource to be downloaded

BAO QUOC NGUYEN

0

10

Resolved: Error Code: player_err_timeout

0

10

Error after Error: Can't create a table this time