MySQL for Beginners Part 2
In Part 2 of this MySQL for beginner’s guide, we’ll cover even more common MySQL commands and show you how to interact with a large database. Check out part one here.
Chapters:
0:00 Introduction
0:50 How to Login to MySQL as the Root User
1:58 How to Use the Show Database Command
2:35 How to Access the Employees Database
3:13 Showing the Tables in the Employee Database
3:37 How to Use the Select Query
5:34 How to Limit the Output
6:40 How to Specify a Specific Column
8:03 How to Select More Than One Column
9:09 How to Filter Out Information
11:35 How to Add In Select Columns
12:39 How to Order the List by a Specific Column
14:32 How to Search Within a Specific Column
17:29 How to Use the Insert Query
22:11 How to Update (or Rename) a Record
24:40 How to Use the Delete Query
26:30 Conclusion
New to Linode? Get started here with a $100 credit.
Read the doc for more information on SQL Commands.
Learn more about MySQL.
Subscribe to get notified of new episodes as they come out.
#Linode #Databases #MySQL #MySQLTutorial
Product: Linode, Database, MySQL; @KeepItTechie;
You might also like…
-
Managed Databases for MySQL Now in General Availability
Choose your Linode plan, select a database engine, and deploy in minutes. -
PostgreSQL Tips From a Pro | Cloud Simplified
In this video, Tim Allen drops in to show us some tips on how to create, backup, delete, and restore a PostgreSQL database. -
Using Databases Has Never Been Simpler | Building a CRUD app in PHP with Linode’s Managed Databases
In this video, Gardiner shows off Linode's worry-free MongoDB Managed Databases by creating a simple Help Desk ticketing system. -
Creating Sorting Lists with SQL and Prisma
In this episode, Austin covers how to set up sorting by using OrderBy properties and create a better experience for the users.