Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations Creating Tables and Manipulating Data with SQL Creating a Table

Ming Jin Edwin Lee
PLUS
Ming Jin Edwin Lee
Courses Plus Student 507 Points
Posted by Ming Jin Edwin Lee
Ming Jin Edwin Lee
Courses Plus Student 507 Points

How do I do a CREATE statement that overwrites an existing table with the same name?

How do I do a CREATE statement that overwrites an existing table with the same name?

E.g. I created a table called actors in the movie_db_1 database. When I try to re-create the table actors with a create table actors (name varchar(50) not null ), it then has an error.

21:31:30 create table actors (name varchar(50) not null) Error Code: 1050. Table 'actors' already exists 0.000 sec

Best Regards, Edwin

2 Answers

Nicholas Hebb
Nicholas Hebb
18,872 Points

Before your create statement, delete the existing table:

DROP TABLE IF EXISTS actors;