PHP Tutorial

MySQL Commands-Creating a Table

MySQL Commands

To use SQL commands first you need to create a database in MySQL and the syntax to create database is:

CREATE DATABASE database_name;

For example: CREATE DATABASE my_project;

Creating a Table

Now, after creating the database we can create tables to store our data and it will contain rows and columns and will have a unique name.

To create a table in MySQL, Create Table statement is used, and we can create the table with any number of rows and columns. Let us see an example:

CREATE TABLE Visitors

(

visitor_id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(40) NOT NULL,

email VARCHAR(50),

)

When you mention the create table statement with table name and the column names with datatype, you can also mention the additional parameters as we have mentioned in the above example. Let us see what the optional attributes means.

NOT NULL – It specifies that every row should contain a value for the particular column.
UNSIGNED – It limits the integer data and only stores zero and positive numbers.
AUTO_INCREMENT – This attribute automatically increases the value by 1 for the column whenever a row is added.
PRIMARY_KEY – It specifies the value should not be blank and should be unique. It is used to identify each row uniquely and is often used for ID numbers.

PHP Tutorial

PHP Introduction

PHP Starters

PHP Forms

PHP Advanced

MySQL Database

PHP OOP

PHP XML

PHP AJAX

PHP Functions

MySQL Commands-Creating a Table

Popular Exams

Company

Resources