There are 154 employee recently joined having 154 different email ids need to be update in database kindly suggest sql query so that i can update the data using single query

New contributor
Amol Gurav is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • 2
  • I suggest you add more data to your question as how are the tables and how is the data looking and how can we reproduce your problem.
    – Peter
    Nov 25 at 8:11
  • i am using following query to update single user email in table at a single time (update employee_master set emp_email='vijayanandmrane@abc.in' where emp_number=38029200; ) now i have 153 more records which is need to update in table but using this query it will update one at a time which is time consuming, so need a sql query which helps me to update all record using single query , i hope this will clarify my quetion
    – Amol Gurav
    Nov 25 at 8:55
  • А general question can only get a general answer. You must provide details.
    – Akina
    Nov 25 at 8:58
  • @AmolGurav - Hi, and welcome to dba.se! Go go dbfiddle.uk and create a fiddle there with your tables, some sample data and then post all of it + the link back here and then there may be a chance that you'll get an answer - otherwise, no hope, there's not enough detail in your question! Also, when people ask for clarification/other info, put that in the question and notify the person using @ and their handle!
    – Vérace
    Nov 25 at 17:39


Your Answer

Amol Gurav is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.