Insert into a MySQL table or update if exists

Any of these solution will work regarding your question:


INSERT IGNORE INTO table (id, name, age) VALUES (1, "A", 19);

or

INSERT INTO TABLE (id, name, age) VALUES(1, "A", 19)
ON DUPLICATE KEY UPDATE NAME = "A", AGE = 19;

or

REPLACE INTO table (id, name, age) VALUES(1, "A", 19);

## Following are some of the possible approaches:

### Using `INSERT INTO`
The [`INSERT`][1] statement allows you to insert one or more rows into a table

* First, specify the table name and a list of comma-separated columns inside parentheses after the `INSERT INTO` clause.
* Secondly, put a comma-separated list of values of the corresponding columns inside the parentheses following the `VALUES` keyword.
```sql
INSERT INTO table_name(column_name1, column_name2, column_name3) VALUES("col_value_1", "col_value_2", "col_value_3");
```


### Using `INSERT INTO` with `WHERE NOT EXISTS` clause

```sql
INSERT INTO table_name (column_name_1, column_name_2, column_name_3)
SELECT * FROM (SELECT "col_value_1", "col_value_2","col_value_3") AS tmp_name
WHERE NOT EXISTS (
SELECT column_name2 FROM table_name WHERE column_name = "sample_name"
) LIMIT 1;
```

### Using `REPLACE INTO`

[`REPLACE`][2] works exactly like [`INSERT`][1], except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted.

```sql
REPLACE INTO table_name(column_name1, column_name2, column_name3) VALUES("col_value_1", "col_value_2", "col_value_3");
```


[1]:

[To see links please register here]

[2]:

[To see links please register here]

Check out [`REPLACE`](

[To see links please register here]

):

> `REPLACE` works exactly like `INSERT`, except that if an old row in the table has the same value as a new row for a `PRIMARY KEY` or a `UNIQUE` index, the old row is deleted before the new row is inserted.

Example:

REPLACE INTO `tablename` (`id`, `name`, `age`) VALUES (1, "A", 19)