Video Tutorials

In this tutorial, we will learn How to import data from a CSV file into MySql table using MySql Workbench?

To create a new database in your MySql Server, following is the general syntax:

CREATE DATABASE <database_name>;

For example:

CREATE DATABASE students; 

The above expression, creates a Database of the name Students in your MySql DBMS (Database Management System). 

Similarly, to create a new table, you will have to following the following expression:

As a Database creator/ administrator, you would like to know the schema of the database.

For that purpose, there is a command DESC which stands for DESCRIBE.

Syntax:

DESC table_name; 

As soon as you will put that, you will see the schema of the table as the result.

For example:

DESC student gives the below result: