Re: [mySQL] insert/update ?

Article View: pl.comp.bazy-danych

Article #195175

Back to pl.comp.bazy-danych Previous Next

#195175

From: Mateusz Bogusz
Date: Wed, 04 Jan 2017 19:59

14 lines
1320 bytes

> Wiem!
> http://stackoverflow.com/questions/12218185/mysql-replace-into-only-some-fields
> by eggyal
> INSERT INTO gfs(localidad, fecha, pp)
> VALUES('some_place', '2012-08-05 02:00', 1.6)
> ON DUPLICATE KEY UPDATE pp=VALUES(pp);

Zwyczajowo tą funkcjonalność szuka się pod hasłem "upsert" :-)

https://www.google.pl/#q=nazwa+bazy+danych+upsert

-- 
Pozdrawiam,
Mateusz Bogusz

Technical Details

Message-ID: <o4jk7d$v79$1@node1.news.atman.pl>

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!.POSTED!not-for-mail

References: <o4gpgv$91d$1@node2.news.atman.pl> <o4gu8v$77u$1@node1.news.atman.pl> <o4h2g1$bom$1@node1.news.atman.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!.POSTED!not-for-mail
From: Mateusz Bogusz <mabakay@o2.pl>
Newsgroups: pl.comp.bazy-danych
Subject: Re: [mySQL] insert/update ?
Date: Wed, 4 Jan 2017 20:59:39 +0100
Organization: ATMAN - ATM S.A.
Lines: 14
Message-ID: <o4jk7d$v79$1@node1.news.atman.pl>
References: <o4gpgv$91d$1@node2.news.atman.pl> <o4gu8v$77u$1@node1.news.atman.pl> <o4h2g1$bom$1@node1.news.atman.pl>
NNTP-Posting-Host: 178-36-243-92.adsl.inetia.pl
Mime-Version: 1.0
X-Trace: node1.news.atman.pl 1483559981 31977 178.36.243.92 (4 Jan 2017 19:59:41 GMT)
X-Complaints-To: usenet@atman.pl
NNTP-Posting-Date: Wed, 4 Jan 2017 19:59:41 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:50.0) Gecko/20100101 Thunderbird/50.0
In-Reply-To: <o4h2g1$bom$1@node1.news.atman.pl>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message