how to create table in MySQL database?

Himmat Kumar Nov 12, 2024, 9:26 AM
MySQL
Views 178
Blog Thumbnail

Create table using SQL Query in MySQL

Create table in my sql database using SQL Query in MySQL

Steps:

  1. Open phpMyAdmin in your system.
  2. Click on the SQL tab.
  3. Paste the query

    CREATE TABLE students (
    studentID int,
    Name varchar(255),
    Email varchar(255),
    Class int,
    Section int
    );

  4. how to create table in mysql database
  5. Click the "Go" button.
  6. You should see a success message.
  7. Refresh the page to check if the Table is created successfully.
  8. how to create table in mysql database

Syntax

CREATE TABLE tablename (
column1 datatype,
column2 datatype,
column3 datatype,
column5 datatype,
column4 datatype,
.....
);

Note : In table name not allow " " space in beetween name use "_" for space.
column1 to column4 is coloum name you can modify and name give you according requirement.
datatype data type basically define a type of column . Example column1 is int show store integer value.

Example of Craete a tabLe in MySQL:

You Can follow statement and create table in Mysql

CREATE TABLE students (
studentID int,
Name varchar(255),
Email varchar(255),
Class int,
Section int
);

when run this statement in sql create a table in your database.
Like studentID, Class, Section datatype is Int this column hold integer value same like Name, Email column datatype is varchar hold character and max-lengh is 255.

Your Student table Looks Like this :
how to create table in mysql database

Comments

Please login to leave a comment.

No comments yet.

Related Posts

how-to-drop-database-in-mysql
97 viewsMySQL
Himmat Kumar Nov 12, 2024, 2:56 AM

How to drop database in MySQL ?

how-to-drop-table-in-mysql-database
158 viewsMySQL
Himmat Kumar Nov 25, 2024, 8:29 AM

how to drop table in MySQL database

what-is-mysql-database
111 viewsMySQL
Himmat Kumar Nov 7, 2024, 4:40 AM

What is MySQL database?

how-to-create-database-in-MySQL
87 viewsMySQL
Himmat Kumar Nov 7, 2024, 7:46 AM

How to create database in MySQL

javascript-functions-and-scope-guide
Himmat Kumar Mar 30, 2025, 5:26 AM

JavaScript Functions & Scope

laravel-vs-cakephp-comparison
1093 viewsLaravel
Himmat Regar 1 May 31, 2025, 7:42 PM

Laravel vs CakePHP (2025) — Which PHP Framework Is Best...

how-to-create-gmail-account-guide-and-steps
160 viewsMail
Himmat Kumar Nov 4, 2024, 7:46 AM

how to create Gmail account ?

what-is-php-advantages-disadvantages-complete-guide
218 viewsPHP
Himmat Kumar Oct 25, 2024, 12:45 PM

What is PHP Advantages and Disadvantages: A Complete 20...

html-tags
400 viewsHTML
Himmat Kumar Oct 19, 2023, 2:45 AM

HTML Tags