create database mypythondb2;

show databases;

use mypythondb2;

Create table Student(RollNo Integer, Name varchar(30));

(Constraints: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK)

show tables;

INSERT INTO student (RollNo, Name) VALUES(1,"John");
INSERT INTO student (RollNo, Name) VALUES(2,"Bob");

SELECT * FROM student;
SELECT * FROM student LIMIT 0,1;
SELECT * FROM student LIMIT 0,2;

SELECT * FROM STUDENT WHERE name LIKE 'J%';
SELECT * FROM STUDENT WHERE name LIKE '_o%';
SELECT * FROM STUDENT WHERE name LIKE '%b';
SELECT * FROM STUDENT WHERE RollNo > 1;

SELECT max(RollNo) FROM STUDENT;
SELECT min(RollNo) FROM STUDENT;
SELECT avg(RollNo) FROM STUDENT;
SELECT sum(RollNo) FROM STUDENT;


desc student;  //to view table structure before alter

alter table Student modify name varchar(50) not null;

desc student;

update student set name = 'Maxx' where RollNo = 2;

(change safe mode to enable updates/deletes : Edit -> Preferences -> SQL Editor -> Uncheck Safe Updates).

SELECT * FROM student;

delete from student where RollNo = 2;

show tables;

drop  table student;

show tables;