Fundamental SQL
Commands: USE, SHOW,
DESCRIBE, and SELECT
MOGALAPALLI MADHUKAR
MySQL: USE Command
Definition :The USE command in SQL is used to select a specific database
that you want to work with.
• Syntax: USE database_name;
• Example: USE employees;
MySQL: SHOW Command
Definition: The SHOW command is
used to display information about
the database, such as the list of
available databases, tables, or other
database objects.
Syntax: SHOW object_name;
Example:
SHOW TABLES; -- Displays a list
of all tables in the current database
SHOW DATABASES; -- Displays a
list of all databases on the server
MySQL: DESCRIBE Command
Definition: The DESCRIBE (or DESC)
command is used to display the structure of
a table, including column names, data types,
and other information like whether a column
can hold NULL values.
Syntax: DESC table_name;
Example:
DESC cleaned_data; -- Shows the
structure of the ‘cleaned_data' table
MySQL: Select Command
Definition:The SELECT command
is used to retrieve data from one or
more tables in a database. It allows
you to specify which columns and
rows you want to see from the
table.
Syntax: SELECT column1,
column2, ... FROM table_name
Example: select sales_method,
Reveune from cleaned_data;
Thank You for Watching!
If you found this content useful, feel free to:
Like the presentation
Comment your thoughts or questions
Connect with me for more insights
