SQL QUERIES
-------------------------------------------------------------------------------------------------------------------------------
-----------
1-> WHERE CLAUSE
SELECT * FROM `management`
WHERE name= 'Ramesh';
SELECT * FROM `management`
WHERE name LIKE = ’R%’;
SELECT * FROM `bran`
WHERE city IN ('Solapur','Delhi');
SELECT * FROM `management`
WHERE name='Ramesh' AND (man_id>2002 OR man_id<2004);
SELECT * FROM `management`
WHERE man_id BETWEEN 2001 AND 2003;
2-> ORDER BY
SELECT * FROM customer
ORDER BY Cus_Name DESC;
3->ARITHMATIC OPr
SELECT * ,Bill-0.05*Bill AS Discounted_bill FROM `portal`;
4-> DISTINCT
SELECT DISTINCT name FROM `management`;
5-> ALTER
If we want to add column.
ALTER TABLE management
ADD COLUMN man_id int(5) NOT NULL;
Only if we have to change constraint,
ALTER TABLE management
ADD UNIQUE KEY(man_id);
For changing column name, datatype and constraint
ALTER TABLE management
CHANGE COLUMN man_id manager_id INT(12)
ADD PRIMARY KEY(manager_id);
If we want to change column datatype ,its size or constraints without changing column name
ALTER TABLE management
MODIFY COLUMN man_id int(5) UNIQUE KEY;
6-> DROP
DROP TABLE Courier;
