Top "Sql-insert" questions

Inserting multiple rows in mysql

Is the database query faster if I insert multiple rows at once: like INSERT.... UNION INSERT.... UNION (I need to …

mysql sql-insert

How to 'insert if not exists' in MySQL?

I started by googling, and found this article which talks about mutex tables. I have a table with ~14 million records. …

php mysql sql primary-key sql-insert

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) …

sql sql-update sql-insert

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 …

sql database oracle sql-insert oracle9i

SQL Error: ORA-01861: literal does not match format string 01861

I am trying to insert data into an existing table and keep receiving an error. INSERT INTO Patient ( PatientNo, PatientFirstName, …

sql oracle sql-insert

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_…

postgresql sql-insert upsert

Avoid duplicates in INSERT INTO SELECT query in SQL Server

I have the following two tables: Table1 ---------- ID Name 1 A 2 B 3 C Table2 ---------- ID Name 1 Z I need …

sql sql-server tsql sql-insert

Column count doesn't match value count at row 1

So I read the other posts but this question is unique. So this SQL dump file has this as the …

mysql wordpress sql-insert

SQL Insert into table only if record doesn't exist

I want to run a set of queries to insert some data into an SQL table but only if the …

mysql sql sql-insert

Saving timestamp in mysql table using php

I have a field in a MySQL table which has a timestamp data type. I am saving data into that …

php mysql database sql-insert