-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name VARCHAR(30) NOT NULL,
  gender CHAR(10) NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M');
INSERT INTO students VALUES (2, 'Joanna', 'F');
-- fetch some values
SELECT * FROM students WHERE gender = 'F';

INSERT INTO students VALUES (03, 'MAYUR','SIGMA');
SELECT * FROM students;

INSERT INTO students (id,name,gender) VALUES (05,'Raftaar','beta');
SELECT * from students;
#UPDATE TABLE COMMAND.
update students set name= 'badshah' where id = 1;
select * from students;