Learning MySQL - SHOW, DESCRIBE, EXPLAIN, and SET

preview_player
Показать описание
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.

Рекомендации по теме
Комментарии
Автор

I just wanted to say that even though the views arent super high your still helping out people immensely. Youve got by far the best MySQL content out there as far as Ive seen and youve helped me learn a ton! So thank you!

Tamam_Shud
Автор

11:27 I believe that's an _'at sign'_ not _'ampersand'_

raz
Автор

Thank you for an amazing explanation/demonstration.

SHOW CREATE TABLE <table> is also worth mentioning.

Strasbourgeois
Автор

man I love you. This is the only video I found about this specific topic day before my exam

banshek
Автор

Thanks for the videos it has help me a lot. Short, clear and easy to follow.

uncledez
Автор

Like for content and comment for "About" . ;) thanks again, nice video.

dinkarinjosh
Автор

I observed Set @xx only works when result set has 1 column and 1 row.

dinkarinjosh