From the course: MySQL for Non-Programmers
Join today to access over 24,800 courses taught by industry experts.
Queries - MySQL Tutorial
From the course: MySQL for Non-Programmers
Queries
- [Instructor] I created the HPlus Database using this script, and the HPlus Database now has data. You can do the same by downloading this script. Now that we have a full database and the database is full of data, how do we get the data from the database? We access the data using queries. You may have seen a query before, especially the most common type of query, the select query. So we go over to this new tab and we already have use HPlus, so we know that we're going to be using the HPlus Database. Using the select query, we will get all the orders in our database by doing select, star, meaning return all the columns, from orders, the semicolon, and then hit the lightning bolt. And as you can see, we now have data and we have all of this data. Okay, now what if we want to only have a few columns? Like TotalDue, Status, and CustomerID. So we only specify the columns we want to see from now, so we expect to see that we're…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.