Cheat Sheet
Let's view the cheat sheet of simple to complex tasks and an example for the demonstration.
We'll cover the following...
Task | Example |
---|---|
What does SQL stand for? | Structured Query Language |
Default Port on which MySQL runs? | 3306 TCP |
Hello World example? | SELECT "Hello World"; |
How to list all databases? | SHOW DATABASES; |
How to select a database to query against? | USE DatabaseName |
How to list storage engines? | SHOW ENGINES; |