Make sure you have MySQL server and Workbench Installed if not You can follow this video : MySQL Installation Video Tutorial for the same : https://www.youtube.com/watch?v=UIHbHv0OZj8 1. Create Database with name 'tg117' mysql> create database tg117 ; 2. Use 'tg117' Database to create table in it mysql> use tg117 ; 3. Create 'student' table in 'tg117' database mysql> create table student(rno int, sname varchar(50), marks float) ; 4. Insert Rows in 'student' table (one Row at a time) mysql> insert into student(rno,sname,marks) values (1,'Katappa',79.87) ;mysql> insert into student(rno,sname,marks) values (2,'Shivgami',49.87) ;mysql> insert into student(rno,sname,marks) values (3,'Chitti',110.04) ; 5. Insert Multiple Rows at a time: mysql> insert into student(rno,sname,marks) values(4,'radhey',78.89),(5,'waghle',77.25),(6,'bhallaldev',87.56) ; 6. Selecting all columns and rows from table mysql> select * from student 7. Selecting rno and marks columns and all rows from student table mysql> select rno,marks from student; 8. Selecting rno and marks columns and first three rows from student table mysql> select rno,marks from student limit 3;
