SQL

sql:
is a language

mysql:
is not a language. je machine  a reke database ar kaj kori satai mysql.

sql ta ke manage korar aro software, engine asa ar modde mysql akta.
http://localhost/phpmyadmin/ ar system ta ke mysql bol jaite pare. database management system tai holo mysql


sql niya kaj:
Using CMD to manage and edit Databases
setting up database,
creating database,
show database.

Cmd: commend prompt option diya kaj korbo


The default is: C:\Users\Ranit>
now i put cd\ that mensa C:\Users\Ranit>cd\ then it's back to C:\>
Now i want to inter a form at c drive the C:\>cd foldername
Now I want to create  make directory then C:\>cd foldername mkdir name
Now i will first find mysql folder the inter bin see mysql.exe

show databases:

Working with table, Insert, Update, Delete:

what is table: where data will set. so for table  we need row and column

Data Type :  we can see all in here and description
https://www.tutorialspoint.com/mysql/mysql-data-types.htm

1 means 1-9
11 means 99999999999
collation is set automatically . If you want to know default then search on google. default collation of mysql data type
utf8_swedish_ci is default

Attributes is default set.
Index primary then the data will be unique . That means the value will be different. so we will on auto increment
for name we will use varchar
one table just one primary

cmd:
CREATE DATABASE

to select database then write use database name.

show tables
to create table: create table()