Question

Where clause
Create Table
18. Write the answers based on the following table:
Table: Manger
Deptname
Sales
Deptno
S101
HR404
P204
AD990
HR
Name
Pranjal Sharma
Preeti Arora
Sukhmeen Singh
Sukanya Kumar
City
Delhi
Chennai
Bangalore
Mumbai
Purchase
Admin
a. Suggest a suitable data type for the Deptname field.
b. Write a query to display all the records of the table.
c. Add a new record with the following details: ('5106', 'Sales', "Kritika Tuteja", "Delhi").
Section D:​

Answer 1

Answer:

The Following is a MySQL code

Explanation:

a) varchar (String Datatype)

b) Select * from Manager;

c) Insert into manager values('5106',"sales", "Kritika Tuteja","Delhi");

Hope this helps you