Example SQL SELECT Commands with MySQL.

Watson Tech World

Watch our full video tutorial on the SQL SELECT statement 👇 https://dai.ly/x9kzs0i --- Get my coloring book, Watson the Time-Travelling Dog 🐕🦖👇 https://watsoncoloringbooks.com/book1-locations/ --- Our website: https://watsontechworld.com --- #SQL #SQLTutorial #MySQL #SQLSelect #LearnSQL #database

Transcript

00:00in MySQL with the same data and showing you how to run it there.

00:07Okay, so this is the same data.

00:13And notice we have a salary table.

00:20And the salary table, this is a MySQL command that says,

00:26tell me about the columns of this table.

00:28And what I'm going to do is say, select star from salary.

00:36And what this does is this gives us the same data.

00:39This is the name column, career, yearly, salary, gender, age, age group.

00:43And that gives the same data.

00:45And notice, yeah, SQL is really incredibly, is amazing.

00:50And you can see the benefits of SQL over using a spreadsheet if you use it enough.

00:56But it really is very, very useful.

00:59Okay, now let's say we want the name, career, and yearly, salary, from salary.

01:08So this is the salary column, or excuse me, the salary table.

01:12So this is the name column, career column, yearly salary column, and the salary table.

01:17So notice here we have the name, career, yearly salary, and so on.

01:23So this is the definition of a model.

01:26So this has the RFPencial.

01:27So that's what we see hoy in the 70s.

01:29Bye, Bye.

01:31Bye.

01:35Bye.

01:36Bye.

01:37Bye.

01:40Bye.

01:43Bye.

01:45Bye.

01:47Bye.

01:48Bye.

01:49Bye.

01:50Bye.

01:51Bye.

01:52Bye.

Category

Transcript

Recommended