database

table

data

• sql - languege
• mysql - software

je languegediye softowre ke bojhabo

• 14/06 - data
• 14/06/2024 - information

1. centralize database - ekta database ache , anek user
2. distributed database - anek database ache distribute, anek user thakte pare, ekhane connected na o thakte pare
3. cloud data - kothay data rakchi seta jani na, mane zomato kothay ranna hoche jani na but khabar peye jachi
4. network database - distubuted moto ,but ekhane connected thakbe database gulo
5. untructure data - chobi , video perticuler database store hoy, er jono no sql database lage, example(mongodb) , semi untructure ,untructure data rakha hoy

show databases;

create database mysql_june_batch;

use mysql_june_batch;

show tables;

create table student_table(
roll_no int primary key not null,
full_name varchar(30) not null,
address varchar(30) not null,
phone_no int not null);

describe student_table;

select * from student_table;

insert into student_table
values (1,"ram","add-1",7865);

insert into student_table
values (2,"sam","add-1",4578);

update student_table
set address="karanjali",phone_no=2000
where roll_no=2;

select * from student_table;

delete from student_table
where roll_no=1;