Top "Sql-insert" questions

The SQL INSERT statement allows you to insert a single or multiple rows into a table.

Insert data from db to another db

I want to take values from my old database tables to new database tables. Old db structure: Table I: Country …

sql sql-server sql-server-2008 sql-insert
ERROR: column of relation does not exist PostgreSQL ,Unable to run insert query

Hi I am trying to insert into a table tester3 it fails when i use the syntax insert into tester3 (…

sql postgresql sql-insert quoted-identifier
Cannot INSERT: ERROR: array value must start with "{" or dimension information

journeypost=# INSERT INTO user_data.user_data (username,randomint) VALUES ('mahman',1); ERROR: array value must start with "{" or dimension information …

arrays postgresql types sql-insert
How to create and insert a JSON object using MySQL queries?

I'm trying to create a JSON object and then read the values from it into MySQL table. But I'm facing …

mysql json nosql sql-update sql-insert
What is a "INSERT IGNORE" equivalent in MS SQL Server?

I am trying to insert records into MySQL database from a MS SQL Server using the "OPENQUERY" but what I …

mysql sql-server sql-insert openquery
MySQL - How to insert into table that has many-to-many relationship

I have a table of persons. Each person has a property and many persons may have a certain property. So …

mysql many-to-many relationship sql-insert
No results returned by the Query error in PostgreSQL

I am trying to insert a data into a table. After executing the query i am getting an exception stating …

java database jsp postgresql sql-insert
SQL INSERT INTO with subquery and value

Is there a way I can use a combination of hard values and a subquery to insert into a table …

sql sql-insert
SQLiteDatabase: Insert only if the value does not exist (not via raw SQL command)

I know there's an SQL command that goes like this: IF NOT EXISTS, but since Android's SQLiteDatabase class has some …

java android android-sqlite sql-insert
Inserting large number of records without locking the table

I am trying to insert 1,500,000 records into a table. Am facing table lock issues during the insertion. So I came …

sql sql-server tsql sql-insert batch-insert