Ticker

6/recent/ticker-posts

How to create a database in MySQL?

How to create a database in MySQL?

How to create a database in MySQL?


In mysql the the data are stored in the form of table and the table are stored in the certain database.

From the above statement you can get a idea about the use of database, in this article we descuise about how to create a database using MySQL queries without delay, let's start!


MySQL queries to create database


CREATE DATABASE database_name;


Example:

CREATE DATABASE lets;

and then

How to create table:


CREATE TABLE table_name(column_name data_type);


Example:

CREATE TABLE frist_table(ID int,stu_name varchar(200),phone_number varchar(20));


In my next article we see next important topics.


Thank you guys, have a nice day!

Post a Comment

0 Comments