MySQL Create Table

MySQL Create Table

How to create a table in MySQL?

We can use the “CREATE TABLE” statement to create a table in MySQL.

A database table has its own name and it must be unique also it has consisted of columns and rows. A table creation command requires three things:

  • Name of the table
  • Names of fields
  • Definitions for each field

Syntax

Here, we will create a table named “student” in the database.

Creating Tables Using PHP Script

What is Next?

In the next section, you will learn how to drop a table in MySQL.

* Please do let us know your views on this article and what type of articles would you are interested to read.

Digiprove sealCopyright secured by Digiprove © 2020

Leave a Reply

Your email address will not be published. Required fields are marked *