Make sure you have MySQL server and Workbench Installed if not You can follow this video : MySQL Installation
Video Tutorial For the Same:
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;
