Create/Drop Table
~10 mins
Prerequisite: Create Database
create database project_db;
use project_db;
Task 1: Create Table
create table employees(id int, name varchar(20));
Task 2: Describe Table
desc employees;
Task 3: Insert Records
insert into employees(id,name) values (1,'Naresh');
insert into employees(id,name) values (2,'Prabhu');
Task 4: Select Records
select * from employees;
Task 5: Drop table
drop table employees;