[mysql] upewnienie się dla ON DUPLICATE KEY UPDATE

Thread View: pl.comp.bazy-danych

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Borneq Tue, 30 Jan 2018 00:25

#195473

Author: Borneq
Date: Tue, 30 Jan 2018 00:25

11 lines
1075 bytes

Mam
INSERT INTO flags
(number, flag1, flag2, flag3)
VALUES (350, 1, 0, 0)
ON DUPLICATE KEY UPDATE
flag1=1

number mam klucz primary

czy wstawia jako nowy wiersz 1,0,0
ale gdy istnieje to nie rusza flag2 i flag3?

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads