MySQL DML - Querying Data

LESSON 1: How to Write a Basic SQL Select Statement - Part 1

This video covers very basic MySQL SELECT syntax. In this lesson you will learn the syntax for a simple SELECT query. We will be using the MySQL Workbench and learning features of this sofware as part of the course. This is part one of the first lesson in this course.


MySQL Topics Covered

  • SELECT keyword
  • SELECT *
  • Selecting specific columns
  • FROM keyword
  • Limit Rows directive

MySQL Workbench Functionality Covered

  • Viewing Table Schema
  • Return the first 1000 rows for a table
  • Running a query
  • Formatting Code
  • Sizing panes