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:
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
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 ;
High Availability Explained | How to Upgrade to High Availability with Linode Kubernetes Engine
You might also like…
Managed Databases for MySQL Now in General AvailabilityChoose your Linode plan, select a database engine, and deploy in minutes.
MacrometaBringing Innovation to the Edge
Managed PostgreSQL on Linode | Simple and Reliable PostgreSQL DatabasesPostgreSQL is an object-relational database management system (ORDBMS) that can use SQL, but is more flexible and feature-rich.
PostgreSQL Tips From a Pro | Cloud SimplifiedIn this video, Tim Allen drops in to show us some tips on how to create, backup, delete, and restore a PostgreSQL database.