title: Mysql SP with custom arguments
body: <p>Im new to mysql stored procedure. Here I have a table <strong>tbl_users</strong> with following fields</p>
  
  <pre><code>id
  first_name
  last_name
  status
  </code></pre>
  
  <p>I have written following SP to update this table.</p>
  
  <pre><code>CREATE PROCEDURE `user_update`(IN var_id INT, IN var_first_name TEXT, IN var_last_name TEXT, IN var_status INT)
  BEGIN    
      UPDATE tbl_users SET first_name = var_first_name, last_name = var_last_name, status = var_status WHERE id = var_id;
  END
  </code></pre>
  
  <p>The above procedure will work fine. The problem, I want to use the same procedure to update the only <strong>status</strong> field. In this situation I have to pass all params with existing values.  Is there any solution, If possible I can reuse the SP in multiple areas... pls help.</p>