MySql database tutorial - part 2

Table structure & Create database, table statements

In this article, you will learn about the Table in MySQL, how to create database and table.

Table in MySQL is like Table in Excel in structure. It has columns (fields), records (rows)

To work with table, you need a database. To create a database, use the syntax below:

CREATE DATABASE database_name;

After create a Database, you can create table:

CREATE TABLE table_name (

    column_name_1 datatype,

    column_name_2 datatype,

    .....

);

You can follow the video below for more details:

‹‹  Prev: Mysql part 1       Next: MySql part 3   ››