
Featured
- 
        No Featured Found!
Tags
Case Sensitive MYSQL select query
                      Case Sensitive SQL query
A  select query does not performs case-sensitive query which means if the user name is pravesh, Pravesh, PRAVESH then it will select all users using simple select. Below example of normal mysql select query -
SELECT... 
                      Delete duplicate row in table
                      You can delete the duplicate row without using the temporary table. You can use the self join concept.
Suppose we have person table contain 3 columns named id, name, and city.
INSERT INTO person(id,name,city) VALUES
(1,'a', 'aa'),
(2,'b','b... 
                       
        
        
 
        
        