table, insert, update, delete

table, insert, update, delete :
how to create a table with commend prompt:

kono database a kaj korte hole use database name dite hoy:
ex CREATE DATABASE advance;
use advance; aito holo akon ai database a kaj korbe. database changed hole.
create table given(
id INT(11) NOT NULL AUTO_INCREMENT,
name varchar(100)  NOT NULL,
roll int(11) NOT NULL,
subject varchar(11) NOT NULL,
semester int(2) NOT NULL,
cgpa float NULL,
PRIMARY KEY (id)
);

table ar column show kortehole  describe or explain use korte pari

column gulo re valu add korbo:

INSERT INTO given (name) VALUES(

NULL,

'RANIT'

);

dakta chile:

SELECT * FROM given for all 

SELECT name, another FROM given tahole specific gulo show korbe

mysel update:

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value 

Delete:

DELETE FROM given WHERE id=1;