Inserting data in MYSQL table [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 9 years ago.

Improve this question

I have same title of products from different stores..lets say... Produt title= A from store= 1 product title = A from store = 2... If store= 1and s title=A only udate price..if store =2 and product =A insert as a new row.. (shouldnt give error of duplications because its from other store).. And if title isnt duplicate simply. Insert it

How to do this with insert query in MYSQL?

Community · Accepted Answer · 2017-05-23 12:23:48Z

0

BEGIN TRAN

UPDATE tablename
SET price = yourprice
WHERE store = 1 and title = A

IF (@@ROWCOUNT = 0)
   INSERT tablename (title, store, price, productid)
VALUES (yourtitle, yourstore, yourprice, yourproductid)

COMMIT

I am unable to test the code, but I copied it from here. Let me know if it helps.

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Mar 2, 2016 at 23:17

Renuka Deshmukh

9989 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Farooq Ch Over a year ago

If title is duplicate(same) store is different insert as a new row? And update if title is same store is same? And insert it simply if title isnt duplicate? How to do this

Renuka Deshmukh Over a year ago

i did not get your comment. Can you explain? Also, why dont you look into if exists then update else insert quesries in mysql ?

Farooq Ch Over a year ago

I have same title of products from different stores..lets say... Produt title= A from store= 1 product title = A from store = 2... If store= 1and s title=A only udate price..if store =2 and product =A insert as a new row.. (shouldnt give error of duplications because its from other store).. And if title isnt duplicate simly. Insert it

Renuka Deshmukh Over a year ago

i updated my answer. hope it helps.

Collectives™ on Stack Overflow

Inserting data in MYSQL table [closed]

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related