Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO table (col1, col2, col3) VALUES ('val1','val2','val3') ON DUPLICATE KEY UPDATE col1=VALUES(col1),STATUS=1
- String usersToConvquery = "INSERT INTO ne_ms_conversation_users (conversationId, userId, role) VALUES (?,?,?) ON DUPLICATE KEY UPDATE role=VALUES(role),STATUS=1";
- stm = connection.prepareStatement(usersToConvquery);
- for (long userId : users) {
- stm.setString(1, conversationId);
- stm.setLong(2, userId);
- stm.setInt(3, 3);
- stm.addBatch();
- }
- int[] insertCount = stm.executeBatch();
- System.out.println(Arrays.toString(insertCount));
- INSERT INTO tbl_emp (emp_id,NAME,city,mobileno,salary) VALUES (21,'cccc','ccccc',95959595,5000)
- ON DUPLICATE KEY UPDATE salary=VALUES(salary)+1;
Add Comment
Please, Sign In to add comment