How to create a database

initially server Is like this

it is the server address

when u click on user accounts

we can acces the required account

create database

 

how to create a table

 

enter the data in tables

enter the name in name
select the type of data in type
enter the length of character in length
select primary in null index	on;y for ist
select AI  means auto incriment	only ist for ist

it appears like thses

click on insert to add data to database

 

before adding of data

before adding of data

how to diplay all the data in that table

if u did any mistake , u can change bu click on change

sql has case insensitive, means it accepts upper case and lower case

A database is an application that stores the organized collection of records. It can be accessed and manage by the user very easily. It allows us to organize data into tables, rows, columns, and indexes to find the relevant information very quickly. Each database contains distinct API for performing database operations such as creating, managing, accessing, and searching the data it stores. Today, many databases available like MySQL, Sybase, Oracle, MongoDB, PostgreSQL, SQL Server, etc. In this section, we are going to focus on MySQL mainly.