Learning MySQL - SHOW, DESCRIBE, EXPLAIN, and SET
This tutorial covers a range of commands including SHOW, DESCRIBE, EXPLAIN, and SET. SHOW and DESCRIBE can be used to find properties of your databases, tables, and columns. EXPLAIN can be used to examine your Queries. SET can be used to create variables that you use in your Queries, functions and stored procedures. MySQL Playlist: • Learning MySQL - Getting Started SHOW reference: https://dev.mysql.com/doc/refman/5.7/... DESCRIBE reference: https://dev.mysql.com/doc/refman/5.7/... EXPLAIN reference: https://dev.mysql.com/doc/refman/5.7/... User defined variable reference: https://dev.mysql.com/doc/refman/5.7/...
▶︎
Learning MySQL - CREATE TABLE
▶︎
How to Analyze and Tune MySQL Queries for Better Performance - MySQL Tutorial
▶︎
Learning MySQL - Using Indexes
▶︎
Learning MySQL - INNER JOINs
▶︎
10 Tips for MySQL Performance Tuning
▶︎
How To Solve SQL Problems
▶︎
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
▶︎
MySQL SELF JOINS are ... ughhh
▶︎
Learning MySQL - SELECT Statements
▶︎
Introduction to PostgreSQL Tutorial - Part 1
▶︎
Learning MySQL - GROUP BY
▶︎
Learning MySQL - FOREIGN KEY CONSTRAINTS
▶︎
#MySQL's EXPLAIN Demystified - Boost your MySQL #Database - MySQL Tutorial
▶︎
Secret To Optimizing SQL Queries - Understand The SQL Execution Order
▶︎
MySQL: INDEXES are awesome
▶︎
SQL Crash Course for Beginners
▶︎
Learning MySQL - LEFT, RIGHT, and self JOINs
▶︎
MySQL Performance Tuning
▶︎
Learning MySQL - JSON in MySQL
▶︎