“Insert if not exists” statement in SQLite
I have an SQLite database. I am trying to insert values (users_id, lessoninfo_id) in table bookmarks, only if both do not exist before … Read more
sql-insert
How to speed up insertion performance in PostgreSQL
I am testing Postgres insertion performance. I have a table with one column with number as its data type. There is an index … Read more
Best way to do multi-row insert in Oracle?
I’m looking for a good way to perform multi-row inserts into an Oracle 9 database. The following works in MySQL but doesn’t seem … Read more
Inserting multiple rows in mysql
This question’s answers are a community effort. Edit existing answers to improve this post. It is not currently accepting new answers or interactions. … Read more
How to insert a value that contains an apostrophe (single quote)?
What is the correct SQL syntax to insert a value with an apostrophe in it? Insert into Person (First, Last) Values ‘Joe’, ‘O’Brien’ … Read more
Postgres: INSERT if does not exist already
I’m using Python to write to a postgres database: sql_string = “INSERT INTO hundred (name,name_slug,status) VALUES (” sql_string += hundred + “, ‘” … Read more
How can I do ‘insert if not exists’ in MySQL?
I started by googling and found the article How to write INSERT if NOT EXISTS queries in standard SQL which talks about mutex … Read more