Apply for Zend Framework Certification Training

Mysql





In Update we seen like updating an single row or multiple rows

UPDATE students
SET 
    name= 'rajesh'
WHERE
    rollno= 6;


can it be like conditional say chane pass into fail or fail into pass

To do this 

UPDATE 
        studnets 
SET grade = 
           CASE grade WHEN 
                             'Pass' THEN 'Fail' WHEN 'Fail' THEN 'Pass'
                              ELSE grade 
           END


Update with Join

UPDATE 
    employee
LEFT JOIN
    salary ON employee.performance = salary.performance 
SET 
    salary = salary + salary * 0.25
WHERE
    salary .performance >= 4;   

< Range in Mysql Important Mysql Query >



Ask a question



  • Question:
    {{questionlistdata.blog_question_description}}
    • Answer:
      {{answer.blog_answer_description  }}
    Replay to Question


Back to Top