HUB OF TUTORIALS
  • Business
  • Digital Marketing
  • Technology
    • HTML
    • CSS
    • jQuery
    • WordPress
    • Core PHP
    • Mysql
    • JAVA
    • Projects
    • Photography
  • Recipes
  • Others
  • Write for Us
HUB OF TUTORIALS
  • Business
  • Digital Marketing
  • Technology
    • HTML
    • CSS
    • jQuery
    • WordPress
    • Core PHP
    • Mysql
    • JAVA
    • Projects
    • Photography
  • Recipes
  • Others
  • Write for Us
  • Business
  • Digital Marketing
  • Technology
    • HTML
    • CSS
    • jQuery
    • WordPress
    • Core PHP
    • Mysql
    • JAVA
    • Projects
    • Photography
  • Recipes
  • Others
  • Write for Us
HUB OF TUTORIALS
  • Business
  • Digital Marketing
  • Technology
    • HTML
    • CSS
    • jQuery
    • WordPress
    • Core PHP
    • Mysql
    • JAVA
    • Projects
    • Photography
  • Recipes
  • Others
  • Write for Us
Core PHPMysql

How to Create Database and tables in MySql

In this article will explain How to Create Database and tables in MySql.

Create a Database

CREATE DATABASE DATABASE_NAME;

In MySql, if you want to display a list of all databases to run the below query.

SHOW DATABASES;

Create Tables:

To create a table in MySQL run below query.

CREATE TABLE IF NOT EXISTS table_name(col type, col type)

Example:

CREATE TABLE IF NOT EXISTS student (
  id int(5) NOT NULL,
  name text(8) NOT NULL,
  rollno int(10) NOT NULL
);

How to Insert Data into Mysql Database using PHP

Read on Facebook

how to create a database how to create table in mysql mysql create database sql create table sql query to create table
How to Print Div in PHP using For LoopPrevHow to Print Div in PHP using For LoopMarch 17, 2020
How to Create Dynamic Dependent select box using ajaxMarch 17, 2020How to Create Dynamic Dependent select box using ajaxNext

Related Posts

Core PHP

How to make a Logout system using PHP and Mysql

Its very simple to How to make a Logout system using PHP and Mysql. This code will...

Rahul Kumar March 17, 2020
Core PHPCSSHTMLMysql

How to Create Dynamic Dependent select box using ajax

You need a dynamic dependent select box. We will explain how to create a dynamic...

Rahul Kumar March 17, 2020
Search
Recent Posts
  • The Power of AI Writing Tools in Transforming Digital Marketing Strategies
  • What is the difference between web design and GUI design?
  • Transforming Your Business with JustEat Like App Excellence
  • The Role of Plagiarism Changers in Enhancing Content Quality
  • How Students Can Increase Their Academic Productivity With Paraphrase Tool?
Categories
  • Business
  • Core PHP
  • CSS
  • Digital Marketing
  • HTML
  • JAVA
  • Jobs
  • jQuery
  • Mysql
  • News
  • Others
  • Photography
  • Projects
  • Recipes
  • WordPress

  • How to Create List in HTML
  • How to use Iframe in HTML
  • How to Create a Table in HTML and CSS
  • How to Add New HTML Content using jQuery
  • CSS Property of List tag in HTML
  • How to use CSS for Table in HTML
  • How to Make Basmati Rice Recipe
  • How to Make Indian Kheer Recipe
  • How to Make Spicy Aloo Tikki
  • How to Make Aloo Matar Samosa
  • How to Make Cheese Potato Sandwich
  • How to Make Aloo Palak Methi
  • Company Visitors Management System
  • Complaint Management System using PHP
  • Directory Management System
  • Employee Record Management System
  • Hospital Management System using PHP
  • Vehicle Parking Management System

Copyright © 2022 Hub of Tutorials. All Rights Reserved. Designed by AS Webworks