Mysql Update Statement with Join

Yes, You can use update statement with mysql join also.

See Below Example

1) Create users Table

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `address` text,
  PRIMARY KEY (`id`)
);

2) Add records in users table.

INSERT INTO `users` (`id`, `name`, `address`) VALUES
(1, 'name 1', 'address 1'),
(2, 'name 2', 'address 2'),
(3, 'name 3', 'address 3'),
(4, 'name 4', 'address 4'),
(5, 'name 5', 'address 5'),
(6, 'name 6', 'address 6'),
(7, 'name 7', 'address 7'),
(8, 'name 8', 'address 8'),
(9, 'name 9', 'address 9'),
(10, 'name 10', 'address 10'),
(11, 'name 11', 'address 11'),
(12, 'name 12', 'address 12'),
(13, 'name 13', 'address 13'),
(14, 'name 14', 'address 14'),
(15, 'name 15', 'address 15');

3) Create salary Table

CREATE TABLE IF NOT EXISTS `salary` (
  `id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL,
  `salary` float(10,2) NOT NULL,
  PRIMARY KEY (`id`)
);

4) Add Record in salary Table

INSERT INTO `salary` (`id`, `user_id`, `salary`) VALUES
(1, 9, 5000.00),
(2, 6, 3500.00);

Requirement : update the user record whose salary is 5000.

Solution with Inner join

update users As u INNER JOIN salary As s on s.user_id=u.id set u.name='my salary is 5000'  where s.salary=5000

Solution with LEFT join

update users As u LEFT JOIN salary As s on s.user_id=u.id set u.name='my salary is 5000'  where s.salary=5000

Solution with Right join

update users As u RIGHT JOIN salary As s on s.user_id=u.id set u.name='my salary is 5000'  where s.salary=5000

Best Related Posts are Following:

1. PHP Mysql Interview Questions and Answers for fresher and experienced.
2. PHP MySQL interview questions and answers for experienced.
3. MySQL Interview Questions and Answers for Experienced.
4. Advanced MySQL Interview Questions and Answers for Experienced.
5. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 2269548 for key PRIMARY.
6. Mysql Privileges - Types of privileages in MySql - How do I grant privileges in MySQL.
7. Calculate a Sum of Time using MySQL.
8. Mysql Interview Questions And Answers - Atomicity, Dedlock, Client Program, Mysql Mode, Mysql Sensitivity Of Identifiers And Mysql Errors.
9. Difference Between Primary Key And Unique Key And Foreign Key And Composite Key.
10. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation - Multilingual Website.
11. MySQL Interview Questions and Answers.
12. MySQL Functions - MySQL tutorial for beginners.
13. mysqlsubqueries examples Scalar Subqueries Row Subqueries Column Subqueries Table Subqueries.
14. Stored Procedure - Advantage of Stored Procedure - Disadvantage of Stored Procedure.
15. Pending Interview Questions and Answers.
16. Differences between Stored Procedures and Functions in MYSQL.
17. MySQL Indexing.
18. Mysql Update Statement.
19. MySQL Constraint Example.
20. MySQL Cascade Example.
21. MySQL Expressions.
22. MySQL Delete Table Example.
23. Replace Table - Update Field, Move Records to another table MySQL.
24. Mysql Update Syntax - Update Multiple Records.
25. What is Mysql.
26. MySQL interview Questions and Answers For Experienced.

Ajax Methods in JQuery

jQuery Load Method
load(): Load a piece of html into a container DOM.

$('#result').load('ajax/test.html');

jQuery GET Method
$.get(): Use this if you want to make a GET call and play extensively with the response.

$.get('ajax/test.html', function(data) {
  $('.result').html(data);
  alert('Load was performed.');
});

jQuery POST Method
$.post(): Use this if you want to make a POST call and don’t want to load the response to some container DOM.

$.post('ajax/test.html', function(data) {
  $('.result').html(data);
});

jQuery AJAX Method
$.ajax(): Use this if you need to do something when XHR fails, or you need to specify ajax options (e.g. cache: true) on the fly.

$.ajax({
  type: "POST",
  url: "some.php",
  data: { name: "John", location: "Boston" }
}).done(function( msg ) {
  alert( "Data Saved: " + msg );
});

jQuery getJSON Method
Return the Response in JSON Format

$.getJSON("/ajax/json_response", function(result){
    console.log(result)
        
    });

Best Related Posts are Following:

1. Top 10 jQuery interview Questions and Answers.
2. How to remove all classes using jQuery?.
3. Jquery Interview Questions and Answers for experienced.
4. jQuery Interview Questions and Answers for experienced.
5. Front End Developer Interview Questions and Answers.
6. How to Add attribute in A-Tag using jQuery.
7. Lightbox vs Fancybox.
8. Important PHP Interview Questions and Answers - jQuery, SQL Modes, Client Programs and Reset.
9. Pending Interview Questions and Answers.
10. Ajax Methods in JQuery.
11. jQuery Interview Questions and Answers.
12. jQuery naming convention - jQuery tutorial for beginner.
13. JQuery Interview Questions And Answers For Experienced.