From the course: Advanced MySQL Data Analysis

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

USE mavenfuzzyfactory;

USE mavenfuzzyfactory; - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

USE mavenfuzzyfactory;

“

- [Instructor] All right, now that we've walked through the database, I'm going to cover the first SQL statement, which is the USE statement. This is pretty simple and it may be review for a lot of you. So if you already know what USE does, go ahead and skip over this. If this is new to you, I think it's pretty important, and we'll do it pretty quick. You may encounter an error that says "no database selected," or you may see an error that says, "table name does not exist in the schema that you're trying to query." The typical underlying cause of this error is you haven't selected the right database schema. So the way that you can do that is by running a statement USE, followed by the schema name that you're going for. So in this course we're always going to use the mavenfuzzyfactory schema, so you can add USE to the top of every query that you have and it will prevent this error from happening. I think the best way to explain this is to run a live demo. So I'm going to jump into…

Contents