From the course: Advanced MySQL Database Administration

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Review: Creating a table

Review: Creating a table

- [Instructor] All right, in this lecture, we're going to be reviewing the create table statement. This one is also review from our MySQL Database Administration for Beginners course. So if you're already a pro at creating tables, you can go ahead and skip this concept. If you're a little shakier or you haven't done this before, you're definitely going to want to watch this one. Creating tables is very important in SQL, and it's fundamental to this course. There's going to be a number of assignments down the road where you'll need to create tables. So make sure that you're comfortable doing this whether you are already or if you want to watch this video. We also do a quick review of the select statement at the end of this video. I think that's probably going to be review for everybody. But again, that's here in case you are not familiar with select yet. So if you feel comfortable that you could create a table and you can name the columns and give those different data types, then you…

Contents