Insert or update a row in SQLite

Question

I found this answer but I'm not sure it does what I want to. It looks like it updates ALL rows in the table, where I only want to update one.

My table is very simple:

MacAddress | Name 1C-6F-65-C6-20-0B | Logan-PC DE-AD-BE-EF-F0-0D | PC1 ...

MacAddress is the PK and I want to simply be able to update Name if it exists or add a new row if it does not, given the MacAddress as references and a Name string.

This is the first time I'm using SQLite so I may just not be understanding Eric B's answer correctly.

INSERT OR REPLACE INTO MyTable ("MacAddress ", "Name") VALUES ("1C-6F-65-C6-20-0B", "PC2") — AllTooSir
– AllTooSir, Commented Apr 20, 2013 at 14:52

sgeddes · Accepted Answer · 2013-04-20 14:56:32Z

The answer you posted seems to work well for me assuming your MacAddress is a primary key in your table.

insert or replace into yourtable (macaddress, name) values ('1C-6F-65-C6-20-0B', 'Logan-PC'); insert or replace into yourtable (macaddress, name) values ('1C-6F-65-C6-20-0B', 'Logan-PC-Updated');

SQL Fiddle Demo

This will result in a single row, with Logan-PC-Updated as the updated name.

NOTE: If your MacAddress is not your primary key, then this method will not work.

Collectives™ on Stack Overflow

Insert or update a row in SQLite

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related