Question

Update scenario is not working properly when using CASEs or IF statement ON DUPLICATE KEY UPDATE section in MySQL

score 47 · Answer 1 · 2024-03-23T16:24:14.133000

47

Views

Update scenario is not working properly when using CASEs or IF statement ON DUPLICATE KEY UPDATE section in MySQL

Published on 23 March 2024 at 16:24

score 66 · Answer 2 · 2024-02-22T18:05:03.413000

66

Views

Mysql on duplicate key condition (IF) setting of one field

Published on 22 February 2024 at 18:05

score 89 · Answer 3 · 2023-12-18T22:19:06.493000

89

Views

How to get list of created/updated indexes from INSERT INTO with ON DUPLICATE KEY UPDATE in SP [MySQL 8.0.36]

Published on 18 December 2023 at 22:19

score 74 · Answer 4 · 2023-11-16T04:01:58.693000

74

Views

mysql ON DUPLICATE KEY UPDATE, check 2 columns at a time

Published on 16 November 2023 at 04:01

score 62 · Answer 5 · 2023-10-19T18:20:18.347000

62

Views

MySQL ON DUPLICATE KEY UPDATE not working as expected

Published on 19 October 2023 at 18:20

score 56 · Answer 6 · 2023-09-26T03:23:36.963000

56

Views

SQL copy and paste table data into that same table by only changing one value

Published on 26 September 2023 at 03:23

score 122 · Answer 7 · 2023-08-17T16:18:53.773000

122

Views

How to add prefix/suffix on a repeatable dictionary key in Python

Published on 17 August 2023 at 16:18

score 74 · Answer 8 · 2023-08-12T15:06:47.407000

74

Views

How to get actual value for duplicate index MongoDB?

Published on 12 August 2023 at 15:06

score 98 · Answer 9 · 2023-07-11T15:33:23.980000

98

Views

SQL MERGE INTO vs UPDATE with not exists

Published on 11 July 2023 at 15:33

score 35 · Answer 10 · 2023-06-16T01:26:42.197000

35

Views

mysql version 5.7.39 query problem condition with on duplicate

Published on 16 June 2023 at 01:26

score 106 · Answer 11 · 2023-04-25T17:08:51.450000

106

Views

MariaDB INSERT - How can I increment a counter on duplicates?

Published on 25 April 2023 at 17:08

score 364 · Answer 12 · 2023-03-31T10:39:45.093000

364

Views

Operand should contain 1 column(s) when trying to update one column

Published on 31 March 2023 at 10:39

score 23 · Answer 13 · 2023-02-20T16:26:54.580000

23

Views

mysqlpp's (Tangensoft) insertfrom with ON DUPLICATE KEY UPDATE

Published on 20 February 2023 at 16:26

score 97 · Answer 14 · 2023-02-13T09:34:41.907000

97

Views

Optimize MySQL on duplicate key update with conditions to update

Published on 13 February 2023 at 09:34

score 60 · Answer 15 · 2023-01-03T19:10:37.300000

60

Views

Should primary key columns be added in the UPDATE?

Published on 03 January 2023 at 19:10

score 63 · Answer 16 · 2022-12-19T17:38:55.870000

63

Views

On Duplicate Key Update with Greatest Value

Published on 19 December 2022 at 17:38

score 1.6k · Answer 17 · 2022-12-03T12:14:22.710000

1.6k

Views

how to handle INSERT on conflict in a has many association in GORM Create, ERROR (SQLSTATE 23505)

Published on 03 December 2022 at 12:14

score 229 · Answer 18 · 2022-11-13T04:57:10.193000

229

Views

How to fix VALUES() deprecation notice in INSERT, ON DUPLICATE KEY UPDATE in MYSQL

Published on 13 November 2022 at 04:57

score 505 · Answer 19 · 2022-11-11T07:43:23.397000

505

Views

Find Duplicate Key Value pairs across all JSON Objects in a JSON file

Published on 11 November 2022 at 07:43

score 242 · Answer 20 · 2022-08-23T13:38:14.537000

242

Views

Pandas: Split dataframe with duplicate values into dataframe with unique values

Published on 23 August 2022 at 13:38

List Question

Update scenario is not working properly when using CASEs or IF statement ON DUPLICATE KEY UPDATE section in MySQL

Mysql on duplicate key condition (IF) setting of one field

How to get list of created/updated indexes from INSERT INTO with ON DUPLICATE KEY UPDATE in SP [MySQL 8.0.36]

mysql ON DUPLICATE KEY UPDATE, check 2 columns at a time

MySQL ON DUPLICATE KEY UPDATE not working as expected

SQL copy and paste table data into that same table by only changing one value

How to add prefix/suffix on a repeatable dictionary key in Python

How to get actual value for duplicate index MongoDB?

SQL MERGE INTO vs UPDATE with not exists

mysql version 5.7.39 query problem condition with on duplicate

MariaDB INSERT - How can I increment a counter on duplicates?

Operand should contain 1 column(s) when trying to update one column

mysqlpp's (Tangensoft) insertfrom with ON DUPLICATE KEY UPDATE

Optimize MySQL on duplicate key update with conditions to update

Should primary key columns be added in the UPDATE?

On Duplicate Key Update with Greatest Value

how to handle INSERT on conflict in a has many association in GORM Create, ERROR (SQLSTATE 23505)

How to fix VALUES() deprecation notice in INSERT, ON DUPLICATE KEY UPDATE in MYSQL

Find Duplicate Key Value pairs across all JSON Objects in a JSON file

Pandas: Split dataframe with duplicate values into dataframe with unique values

Trending Questions

Popular # Hahtags

Popular Questions