To retrieve data from a table in a MySQL database using the SELECT statement, you can use various clauses to filter, sort, and manipulate the data. Here’s a guide to help you get started:

Basic Syntax

SELECT column1, column2, ... 
FROM table_name;

- column1, column2, ...: The columns you want to retrieve. You can also use  to select all columns.
- table_name: The name of the table you want to query.

 Examples of SELECT Statements

1. Select All Columns:

How to import data from a CSV file into MySql table using MySql Workbench?

To create a table in MySQL, you use the CREATE TABLE statement. Here’s the basic syntax:

CREATE TABLE table_name (
    column1_name column1_datatype constraints,
    column2_name column2_datatype constraints,
    ...
);

Example - 
Here’s a real-world example to create a simple employees table:

The database INFORMATION_SCHEMA contains the database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data dictionary and system catalog.

To pull the column names of a MySQL Table, you will have to use the below query - 

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'youtube'
AND TABLE_NAME = 'videoslist';