## 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]