Scribd
Upload
4 views17 pages

Essential MySQL Queries Guide

file imp

Uploaded by

harshuubelal007
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views17 pages

Essential MySQL Queries Guide

file imp

Uploaded by

harshuubelal007
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

MYSQL QUERIES

Write a query to create a table.


Write a query to describe a table.
Write a query to insert values in the table.
Write a query to show all the records from the
table.
Write a query to show specific records from
the table employee.
Write a query to add a new column.
Write a query to delete any record from the
table.
Write a query to delete any column from the
table.
Write a query to modify column properties in
a table.
Write a query to rename a column in the
table.
Scalar expression with selected fields
Write a query to update a record where
salary=50000.
RELATIONAL OPERAT0R
Write a query to show the records of the
employee whose salary >20000.
Write a query to show the records of the employee whose
salary is between 20000-50000
Write a query to show the name of the employee starting
from s.

Write a query to show the name of the employee ending at


h
SORTING
Write a query to show the name of the employee in
arranging order.
Write a query to show the salary in descending order.

You might also like