Copy/Paste following commands in mysql workbench for creating table and inserting data in it create database if not exists tg117 ;use tg117 ;drop table employee;create table employee(eid int,ename varchar(30), monthly_salary…
MySQL | Order By Complete Explanation | The SQL Gym
Execute following code in MySQL WorkBench, and Let’s start with exercise create database if not exists tg117; use tg117; create table employee(eid int,ename varchar(50),city varchar(20),dept varchar(20),salary float) ;insert into employee(eid,ename,city,dept,salary)…
MySQL | Creating Tables and Insertiing Rows In It
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…