Главная
Study mode:
on
1
Introduction
2
How to Login to MySQL as the Root User
3
How to Use the Show Database Command
4
How to Access the Employees Database
5
Showing the Tables in the Employee Database
6
How to Use the Select Query
7
How to Limit the Output
8
How to Specify a Specific Column
9
How to Select More Than One Column
10
How to Filter Out Information
11
How to Add In Select Columns
12
How to Order the List by a Specific Column
13
How to Search Within a Specific Column
14
How to Use the Insert Query
15
How to Update or Rename a Record
16
How to Use the Delete Query
17
Conclusion
Description:
Learn essential MySQL commands and techniques for working with large databases in this comprehensive video tutorial. Discover how to log in as the root user, navigate databases, and perform various operations on the employees database. Master the SELECT query to retrieve specific data, apply filters, limit output, and order results. Explore advanced techniques like searching within columns, inserting new records, updating existing data, and deleting entries. Gain practical skills to effectively manage and manipulate MySQL databases, building upon the foundations covered in the first part of this beginner's guide.

MySQL for Beginners - Working With Data

Linode
Add to list
0:00 / 0:00