šŸ·ļø LIMITED TIME OFFER: GET 20% OFF GRADE+ YEARLY SUBSCRIPTION ā†’
Log in
Information Technology
23
answers
0
watching
119
views
2 Dec 2019

Write a query in MYSQL to 1) delete a row in a table, 2) delete a column, 3) delete a table, 4) delete a database.

Watch
23
answers
0
watching
119
views

For unlimited access to Homework Help, a Homework+ subscription is required.

Avatar image
Liked by alizy and 1 others

Unlock all answers

Get 1 free homework help answer.
Get unlimited access
Already have an account? Log in
Share
Get unlimited access
Already have an account? Log in
Share
Get unlimited access
Already have an account? Log in
Share
Get unlimited access
Already have an account? Log in
Share
Get unlimited access
Already have an account? Log in
Share
Get unlimited access
Already have an account? Log in
Share
Get unlimited access
Already have an account? Log in
Share
Get unlimited access
Already have an account? Log in
Share
Get unlimited access
Already have an account? Log in
Share
Get unlimited access
Already have an account? Log in
Share
Get unlimited access
Already have an account? Log in
Share
Get unlimited access
Already have an account? Log in
Share
Get unlimited access
Already have an account? Log in
Share
Get unlimited access
Already have an account? Log in
Share
Get unlimited access
Already have an account? Log in
Share
Avatar image
Read by 1 person
Get unlimited access
Already have an account? Log in
Share
Avatar image
Read by 1 person
Get unlimited access
Already have an account? Log in
Share
Avatar image
Read by 1 person
Get unlimited access
Already have an account? Log in
Share
Avatar image
Read by 1 person
Get unlimited access
Already have an account? Log in
Share
Avatar image
Read by 1 person
Get unlimited access
Already have an account? Log in
Share
Avatar image
Read by 1 person
Get unlimited access
Already have an account? Log in
Share
Avatar image
Read by 1 person
Get unlimited access
Already have an account? Log in
Share
Jean Keeling
Jean KeelingLv2
2 Dec 2019
Get unlimited access
Already have an account? Log in
Share

Related questions

Create a database with the following tables and write queries in MySQL:

SALESMAN{SID, FNAME, LNAME, PRODID, QUAN, AMT}

PRODUCT{PID, PNAME, IN_STOCK}

  1. Write an SQL Query to display the first names of the salesperson in the upper case using the alias FIRST_NAME.

  2. Write an SQL COMMAND to display the names of the products that are out of stock.

  3. Write an SQL Query to display the details of the salesperson whose sale_amount is the second highest.

What part of a database can be used for requesting data?

1.  Tables

2.  Query

3.  Forms

4.  Reports

Mention any three features of a database system. Again, write queries to -

EmpDetails

EmpIdĀ  Ā  Ā ENameĀ  Ā  Ā  Ā ManagerIdĀ  Ā DateOfJoining

Ā 121Ā  Ā  Ā  Mina RoutĀ  Ā  Ā  Ā  Ā 321Ā  Ā  Ā  Ā  Ā  01/31/2018

Ā 321Ā  Ā  Ā  John WhiteĀ  Ā  Ā  Ā 986Ā  Ā  Ā  Ā  Ā  01/20/2017

Ā 421Ā  Ā  Ā  Manish RanaĀ  Ā  Ā 876Ā  Ā  Ā  Ā  Ā  27/12/2017

  1. Write An SQL query to fetch the names of the employees who have joined in 2017.

  2. Write a query to show the managerā€™s names.

Weekly leaderboard

Home
Homework Help 3,900,000
Information Technology 3,000
Start filling in the gaps now
Log in